ExcelBanter - ABS in SUBTOTAL

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - ABS in SUBTOTAL (https://www.excelbanter.com/excel-discussion-misc-queries/262210-abs-subtotal.html)

whymj

ABS in SUBTOTAL

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

ABS in SUBTOTAL

=SUMPRODUCT(ABS(D2:D7))

Assuming that all the numbers needed are in cells D2:D7
--
Wag more, bark less

"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!

dlw

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!

Teethless mama

ABS in SUBTOTAL

=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!

All times are GMT +1. The time now is 05:46 AM.