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