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

[avidcat]

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

[teylyn]

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.

[DonkeyOte]

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

Please Login or Register  to view this content.

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.

[avidcat]

Thanks to both of you, I actually took your advice and created a hidden helper column and placed the absolute values there and grabbed the totals from that.

I appreciate your help.

thanks,
Nick