| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Using sum function with absolute numbers
I am trying to get the absolute average of a column of positive and negative
numbers, so i am trying to gather the absolute sum of the numbers using the following: =SUM(ABS($F3:$F216)) however it returns a number (1) that isn't the correct answer. However when i hit the function key in the formula bar the correct answer is displayed under the inputs. What am I doing wrong? Please help/ |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Turning forumula results as absolute numbers | Excel Discussion (Misc queries) | |||
| Can I change a column of calculated numbers to absolute numbers? | Excel Discussion (Misc queries) | |||
| How do I get the maximum absolute value of a range of numbers? | Excel Discussion (Misc queries) | |||
| sum absolute values of a column of numbers in Excel | Excel Worksheet Functions | |||
| can excel report scientific values rather than absolute numbers? | Excel Discussion (Misc queries) | |||
Threaded Mode
