Absolut Value

[Guest]

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?

 

[Andy Brown]

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?

=ABS(SUM(range))

 

[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)