Re: Using sum function with absolute numbers

Tech-Archive recommends: Fix windows errors by optimizing your registry

Array enter the formula by holding down Ctrl & Shift while you press Enter.
This will automatically put curly braces { } around the formula and it will
then correctly calculate.

--
HTH

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings

sandymann2@xxxxxxxxxxxxxx
Replace @mailinator.com with @tiscali.co.uk


"mebsmith" <mebsmith@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:C8A54713-99D6-467E-B831-B574B67AB4E7@xxxxxxxxxxxxxxxx
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/



.

Quantcast