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



"whymj" wrote:

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!