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

On Feb 23, 5:24*pm, E2 wrote:
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 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)
--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"E2" wrote:

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

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)

--
If this helps, please click the Yes button

Cheers,
Shane Devenshire


"E2" wrote:

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

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
"E2" wrote in message
...
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