ABS in SUBTOTAL

[whymj]

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]

=SUMPRODUCT(ABS(D27))

Assuming that all the numbers needed are in cells D27

 

[dlw]

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

 

[Teethless mama]

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