Using sum function with absolute numbers
Hi,
Well, as you can see there is a common solution, but here are two others
that don't require SHIFT+CTRL+ENTER
=SUMPRODUCT(ABS($F3:$F216))
or
=SUMIF($F3:$F216,"0")-SUMIF($F3:$F216,"<0")
--
Thanks,
Shane Devenshire
"mebsmith" wrote:
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/
|