Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Using ABS() in a range of cells
Hi, I got a table lookin something like this
-4 3 6 -3 -2 I want to add all these numbers up using ABS() But I cant seem to get it right. What I tried was =SUM(ABS(A1:A4)) but that seems to be the wrong funktion. It works if I write =SUM(ABS(A1);ABS(A2)...) but this seems idiotic hehe /Chris |
#2
|
|||
|
|||
=SUM(ABS(A1:A4)) is the right formula, but you need to commit it as an array
formula, meaning you commit it by pressing Ctrl-Shift-Enter, rather than simply Enter "ChrisP" wrote: Hi, I got a table lookin something like this -4 3 6 -3 -2 I want to add all these numbers up using ABS() But I cant seem to get it right. What I tried was =SUM(ABS(A1:A4)) but that seems to be the wrong funktion. It works if I write =SUM(ABS(A1);ABS(A2)...) but this seems idiotic hehe /Chris |
#3
|
|||
|
|||
your formula needs to be array entered (ctrl+shift+enter) instead of simply
enter. and after you did so you will see 2 braces before and after the formula as shown below {=SUM(ABS(A1:A4))} "ChrisP" wrote in message ... Hi, I got a table lookin something like this -4 3 6 -3 -2 I want to add all these numbers up using ABS() But I cant seem to get it right. What I tried was =SUM(ABS(A1:A4)) but that seems to be the wrong funktion. It works if I write =SUM(ABS(A1);ABS(A2)...) but this seems idiotic hehe /Chris |
#4
|
|||
|
|||
The other option is the non-array formula...
=SUMPRODUCT(ABS(A1:A5)) HTH -- Dana DeLouis Win XP & Office 2003 "ChrisP" wrote in message ... Hi, I got a table lookin something like this -4 3 6 -3 -2 I want to add all these numbers up using ABS() But I cant seem to get it right. What I tried was =SUM(ABS(A1:A4)) but that seems to be the wrong funktion. It works if I write =SUM(ABS(A1);ABS(A2)...) but this seems idiotic hehe /Chris |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
What formula is used for subtracting a range of different cells f. | Excel Worksheet Functions | |||
Counting empty cells within a range of cells | New Users to Excel | |||
Counting empty cells within a range of cells | New Users to Excel | |||
Applying formula to only NON-EMPTY cells in range | Excel Discussion (Misc queries) | |||
How do you delete one cell from a range of protected cells | Excel Worksheet Functions |