Absolute function

[Guest]

I am trying to add a row of number to total their absolute value. The actual
total may be 0, but if there are numbers in the row, I want to have a total
above 1. For example the row may have the following:

1 24 -24 -1

I do not want the total to be 0, but rather to be 50. Using ABS (sum(cell
range)) does not work. Any ideas?

Thanks

 

[Guest]

{=SUM(ABS(yourrange))}

Press Ctrl+Shift+Enter when you are done writing the formula without the
curly brackets--Excel puts those in for you.

tj

 

[Guest]

That does work as long as I exlude a column where I have a letter (denoting a
footnote reference - that gave me a #VALUE error. Thank you so much!

 

[Aladin Akyurek]

You need to filter the range for numbers...

=SUM(IF(ISNUMBER(Range),ABS(Range)))

which must be confirmed with control+shift+enter instead of just wit
enter.

That does work as long as I exlude a column where I have a lette
(denoting a
footnote reference - that gave me a #VALUE error. Thank you so much!

[...