ABS in SUBTOTAL

whymj · Apr 22, 2010

How can I subtotal the Absolute Values in a column? I can SUM by
=SUM(ABS(A1:A10)) Ctrl-Shift-Enter.
I have tried =SUBTOTAL(9,(ABS(A1:A10)) with both Enter and Ctrl-Shift-Enter
with no luck.
Any suggestions?
Thanks!

Brad · Apr 22, 2010

=SUMPRODUCT(ABS(D2

7))

Assuming that all the numbers needed are in cells D2

7

dlw · Apr 22, 2010

insert a helper column that contains the abs values and subtotal on that.

Teethless mama · Apr 23, 2010

=SUMPRODUCT(SUBTOTAL(3,OFFSET(A2,ROW(A2:A20)-ROW(A2),0))*ABS(A2:A20))

ABS in SUBTOTAL

whymj

Brad

dlw

Teethless mama