Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Sum of a range of absolute numbers
I need to sum a row of numbers that are both positive and negative. What I
would like to do is sum them as absolute values. Example: A1=2, B1=-3, C1=-1, D1=5 Sum(abs(A1:D1)) should equal 11 (2+3+1+5) not 3 (2-3-1+5). This doesn't work. Does anyone have a suggestion on how to do this. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Sum of a range of absolute numbers
SteveG,
Please use: =SUMPRODUCT(ABS(A1:D1)) -- --Thomas [PBD] Working hard to make working easy. Answered your question? Click ''Yes'' below. "SteveG" wrote: I need to sum a row of numbers that are both positive and negative. What I would like to do is sum them as absolute values. Example: A1=2, B1=-3, C1=-1, D1=5 Sum(abs(A1:D1)) should equal 11 (2+3+1+5) not 3 (2-3-1+5). This doesn't work. Does anyone have a suggestion on how to do this. |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Sum of a range of absolute numbers
You need to enter your formula as an array formula. After you type it in,
press Ctrl-Shift-Enter instead of Enter. If you do it correctly, Excel will wrap curly brackets {} around your formula (don't type them yourself.) You could also use SUMPRODUCT instead (it's entered like any normal function): =SUMPRODUCT(ABS(A1:D1)) Hope this helps, Hutch "SteveG" wrote: I need to sum a row of numbers that are both positive and negative. What I would like to do is sum them as absolute values. Example: A1=2, B1=-3, C1=-1, D1=5 Sum(abs(A1:D1)) should equal 11 (2+3+1+5) not 3 (2-3-1+5). This doesn't work. Does anyone have a suggestion on how to do this. |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Sum of a range of absolute numbers
Steve,
Your formula =Sum(abs(A1:D1)) Will give the correct answer if you enter it by pressing Ctrl+Shift+Enter and NOT just enter. If you do it correctly excel will put curly brackets around it {}. You cant type these yourself. Mike "SteveG" wrote: I need to sum a row of numbers that are both positive and negative. What I would like to do is sum them as absolute values. Example: A1=2, B1=-3, C1=-1, D1=5 Sum(abs(A1:D1)) should equal 11 (2+3+1+5) not 3 (2-3-1+5). This doesn't work. Does anyone have a suggestion on how to do this. |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Sum of a range of absolute numbers
This worked great. Thanks.
"Thomas [PBD]" wrote: SteveG, Please use: =SUMPRODUCT(ABS(A1:D1)) -- --Thomas [PBD] Working hard to make working easy. Answered your question? Click ''Yes'' below. "SteveG" wrote: I need to sum a row of numbers that are both positive and negative. What I would like to do is sum them as absolute values. Example: A1=2, B1=-3, C1=-1, D1=5 Sum(abs(A1:D1)) should equal 11 (2+3+1+5) not 3 (2-3-1+5). This doesn't work. Does anyone have a suggestion on how to do this. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Can you make a range absolute? | Excel Discussion (Misc queries) | |||
name range from absolute to relative | Excel Worksheet Functions | |||
Can I change a column of calculated numbers to absolute numbers? | Excel Discussion (Misc queries) | |||
Sum a range of absolute values | Excel Worksheet Functions | |||
How do I get the maximum absolute value of a range of numbers? | Excel Discussion (Misc queries) |