| Home |
| Search |
| Today's Posts |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I sum the absolute values of a range of cells?
Chip Pearson wrote:
Use the following array formula: =SUM(ABS(A1:A10)) Since this is an array formula, you must press CTRL+SHIFT+ENTER rather than just ENTER when you first enter the formula and whenever you edit it later. If you do this properly, Excel will display the formula enclosed in curly braces {}. Or =SUMPRODUCT(ABS(A1:A10)) which does not need to be entered as an array formula. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Copy/Paste how to avoid the copy of formula cells w/o calc values | Excel Discussion (Misc queries) | |||
| Automatically clear values from a range of selected cells | Excel Discussion (Misc queries) | |||
| Counting empty cells within a range of cells | New Users to Excel | |||
| How To Use Cells Without Values in a Formula | Excel Worksheet Functions | |||
| Applying formula to only NON-EMPTY cells in range | Excel Discussion (Misc queries) | |||
Threaded Mode
