Try in say, B1: =SUMIF(A:A,"0")
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"my47620" wrote in
message ...

I want to be able to total up a column of numbers, sometimes there will
be negative numbers in this column that I want to ignore, how can I
write the formula to ignore all negative numbers.


--
my47620
------------------------------------------------------------------------
my47620's Profile:
http://www.excelforum.com/member.php...o&userid=28522
View this thread: http://www.excelforum.com/showthread...hreadid=508667