| 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 |
| 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 | |||
Threaded Mode
