Sum With Criteria Ignoring Negative Signs

bbromley · Dec 30th 2006

Hi there,
I am trying to nest an ABS function inside a SUMIF equation. Not sure if it is possible. Basically trying to sum the absolute values of a list of data if certain criteria are met. The formula I am trying to get is something like this...
SUMIF($A$1:$M$1,"=P",ABS($A$8:$M$8))
Any thoughts on how I can achieve this greatly appreciated

tinyjack · Dec 30th 2006

Re: Abs Function Nested In Sumif Equation?

Have a look at SUMPRODUCT:

=SUMPRODUCT((A1:M1="p")*ABS(A8:M8))

HTH

TJ

bbromley · Dec 30th 2006

Re: Abs Function Nested In Sumif Equation?

OF COURSE!!!
Thanks TJ

Sum With Criteria Ignoring Negative Signs

Participate now!

Share