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