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...
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"))
