Formula:

  • Thread starter Thread starter E2
  • Start date Start date
E

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
 
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
 
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)
 
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)
 
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
 
Back
Top