Ignoring negative number

[my47620]

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.

 

[Max]

Try in say, B1: =SUMIF(A:A,">0")

 

[my47620]

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

 

[Roger Govier]

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