ABS in SUBTOTAL
insert a helper column that contains the abs values and subtotal on that.
"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!
|