Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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! |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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! |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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! |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
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! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Subtotal To Include Item Description On Subtotal Line | Excel Discussion (Misc queries) | |||
sort macro, subtotal and add lines after subtotal | Excel Discussion (Misc queries) | |||
pasting to subtotal lines without replacing hidden -non-subtotal l | Excel Discussion (Misc queries) | |||
Bolding the subtotal lines automaticlly When using the Subtotal fu | New Users to Excel | |||
Subtotal of Subtotal displays Grand Total in wrong row | Excel Worksheet Functions |