Formula:

[E2]

Want to sum all values of column, containing both negative and positive
values. I either receive a "Zero" for a answer or some values are being
ignored.
Any suggestions?
Thanks
Earl

 

[Pete_UK]

Do you mean that you want to treat negative values as if they are
positive? If so you can do this:

=SUMIF(A:A,">0",A:A) - SUMIF(A:A,"<0",A:A)

If not, then this should suffice:

=SUM(A:A)

where both assume that your values are in column A.

Hope this helps.

Pete

 

[Luke M]

Do you mean that 2+(-1) should end up equalling 1, or 3?
Former:
=SUM(B1:B100)
Latter:
=SUM(ABS(B1:B100))
This one must be entered as an array (Use Ctrl+Shift+Enter to confirm formula)

 

[Shane Devenshire]

Hi,

1. Maybe its the correct answer -2 +2 should be 0.
2. Some or all of your entries may be text in which case you can convert
them to number or use the formula
=SUMPRODUCT(--I27:I35)

 

[Otto Moehrbach]

Some of your "numbers" may actually be text. To force all numbers to be
numbers, enter a 1 in some otherwise blank cell. Select that cell. Do
Edit - Copy. Select all the numbers you have and do Edit - PasteSpecial -
Multiply - OK. HTH Otto