Absolut Value

K

Kerry

I need to add/subtract cells together in a very large spreadsheet, and one
column that I am working with came out as all negative numbers, s there any
way to add something into my sum function so that I can make the numbers
potivie?
 
A

Andy Brown

Kerry said:
I need to add/subtract cells together in a very large spreadsheet, and one
column that I am working with came out as all negative numbers, s there
any
way to add something into my sum function so that I can make the numbers
potivie?
Click to expand...

=ABS(SUM(range))
 
B

Bob Phillips

.... or maybe

=SUM(ABS(rng))

which is an array formula, it should be committed with Ctrl-Shift-Enter, not
just Enter.
Excel will automatically enclose the formula in braces (curly brackets), do
not try to do this manually.
When editing the formula, it must again be array-entered.

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)
 
Top