Forum Discussion
SumIfs
Attached is the Formula Builder for the SUMIFS Function
The criteria!is 10.01. The value in that cell is a negative number.
Question: What do I need to do to return the value as positive number
Thank you
You could use
=-SUMIFS(H2:H500, G2:G500, 10.01, K2:K500, "Pymt")
or
=ABS(SUMIFS(H2:H500, G2:G500, 10.01, K2:K500, "Pymt"))
