You need to enter it with ctrl + shift & enter since it is an array formula

--


Regards,


Peo Sjoblom

"mebsmith" wrote in message
...
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/