Thread
:
Using sum function with absolute numbers
View Single Post
#
5
Posted to microsoft.public.excel.worksheet.functions
Sandy Mann
external usenet poster
Posts: 2,345
Using sum function with absolute numbers
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
Replace @mailinator.com with @tiscali.co.uk
"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/
Reply With Quote
Sandy Mann
View Public Profile
Find all posts by Sandy Mann