ABS

[Zubair]

Hi Team,

Can you please teach me how to add ABS in my given formula, I want ABS to convert negative to positive.

=IF(MATCH($D$201,$FK$1:$FV$1,0)<=MATCH($B$2,$FK$1:$FV$1,0),SUMIFS(TB!$J:$J,TB!$G:$G,$A214,TB!$F:$F,F$2)+SUMIFS(F$3:F$199,$B$3:$B$199,$A214),0)

 

[Joe4]

Yes, it is always a good idea to test the formulas first before posting them to make sure that they are valid.

 

[Fluff]

SUMIFS requires a range, which is why it will not work when you put the sum range inside the ABS as that will return an array.
Also your SUM formula will only work like that in 365 (which is not what the OP is using), in all other versions it will need array entry.

 

[Zubair]

Many thanks *Radoslaw, Fluff, Joe4 for your help.

 

[Fluff]

Glad we could help & thanks for the feedback.