Thread: Formula change to gather the Absolute ABS sum instead of the net

I am using the following forumla, it gathers the net sum of a column of $ amounts.

I need to have it changed to gather the Absolute ABS total instead.

=SUMIFS($B$23:$B$500,$A$23:$A$500,">="&$V23,$A$23:$A$500,"<"&EDATE($V23,1))

V23 has a date "Month" value.

thanks for any help.

Nick

Not sure what you mean with "ABS" but somehow I think you may not be referring to the ABS() function, right?

Your formula sums the values in column B if they meet the specified conditions. If column B holds your "net" values, and you want to sum your "ABS" values instead, just replace the reference to column B with a reference to the column that holds the "ABS" values.

If you don't have a column of ABS values (worth adding) then you would need to revert to SUMPRODUCT (less efficient)

=SUMPRODUCT(--($A$23:$A$500>=$V23),--($A$23:$A$500<EDATE($V23,1)),ABS($B$23:$B$500))

the above would generate an error should any value in the summation range contain non-numerics (ABS will coerce) - if that's an issue then you would be best served reverting to a SUM based Array.