Ignoring negative number
 

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

Ignoring negative number
 

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

Ignoring negative number
 

I don't understand what you mean. How would I write the formula if I
want to add say B1=A1+A2+A3+A4 and if any of these have a negative
number it will ignore it when it puts it in B1. Thanks


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

Ignoring negative number
 

Try what Max gave you.
That is exactly what it will do, sum all values in column A that are
great than 0.
If you don't want the whole column, then limit the range
=SUMIF(A1:A10,"0")

--
Regards

Roger Govier


"my47620" wrote
in message ...

I don't understand what you mean. How would I write the formula if I
want to add say B1=A1+A2+A3+A4 and if any of these have a negative
number it will ignore it when it puts it in B1. Thanks


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