Refer to the corresponding Cell in another column in SUMIFS

[SanjayGMusafir]

Hi Experts

I'm using a SUMIFS formula that was working fine till today. Now I want a new dimension added to it which I'm not able to figure out. If you may please help.

Required -
If there is some value in Banks[Less] and there is a corresponding Value in Banks[Add] then it should subtract that amount from the total. But should ignore all such values in Banks[Add] where there is no value/blank in Banks[Less].

The formula I'm using right now is...

Thanks in Advance

=IFS(TODAY()<DATE(YEAR(TODAY()),8,2),
ROUND(50000-SUMIFS(Banks[Less],Banks[Acc],"CC SH ICICI",Banks[D1],"<>"&"Petrol",Banks[Dt],">="&DATE(YEAR(TODAY())-1,8,2),Banks[Dt],"<"&DATE(YEAR(TODAY()),8,2),Banks[Dt],"<="&TODAY()),2),
TRUE,
ROUND(50000-SUMIFS(Banks[Less],Banks[Acc],"CC SH ICICI",Banks[D1],"<>"&"Petrol",Banks[Dt],">="&DATE(YEAR(TODAY()),8,2),Banks[Dt],"<"&DATE(YEAR(TODAY())+1,8,2),Banks[Dt],"<="&TODAY()),2))

 

[SanjayGMusafir]

I solved it by doing...

Any better way of doing it...

=IFS(TODAY()<DATE(YEAR(TODAY()),8,2),
ROUND(50000-
(SUMIFS(Banks[Less],Banks[Acc],"CC SH ICICI",Banks[D1],"<>"&"Petrol",Banks[Dt],">="&DATE(YEAR(TODAY())-1,8,2),Banks[Dt],"<"&DATE(YEAR(TODAY()),8,2),Banks[Dt],"<="&TODAY())
-SUMIFS(Banks[Add],Banks[Less],"<>"&"",Banks[Acc],"CC SH ICICI",Banks[D1],"<>"&"Petrol",Banks[Dt],">="&DATE(YEAR(TODAY())-1,8,2),Banks[Dt],"<"&DATE(YEAR(TODAY()),8,2),Banks[Dt],"<="&TODAY())),2),
TRUE,
ROUND(50000-
(SUMIFS(Banks[Less],Banks[Acc],"CC SH ICICI",Banks[D1],"<>"&"Petrol",Banks[Dt],">="&DATE(YEAR(TODAY()),8,2),Banks[Dt],"<"&DATE(YEAR(TODAY())+1,8,2),Banks[Dt],"<="&TODAY())
-SUMIFS(Banks[Add],Banks[Less],"<>"&"",Banks[Acc],"CC SH ICICI",Banks[D1],"<>"&"Petrol",Banks[Dt],">="&DATE(YEAR(TODAY()),8,2),Banks[Dt],"<"&DATE(YEAR(TODAY())+1,8,2),Banks[Dt],"<="&TODAY())),2))