Formula:
 

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

Formula:
 

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

Formula:
 

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

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)

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

Formula:
 

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