On Wed, 29 Jun 2005 07:31:11 -0700, "Matt"
wrote:

I am having trouble creating an If and Or statement:
My spreadsheet looks like this:
A1 100
A2 200
A3 300
A4 600

A4 is just a sum of the 3 cells above it. I want to say if any of the cells
above the total line is negative then dont add that particular cell. I can do
it if one cell is negative but what about 2?

=SUMIF(A1:A3,"0")




--ron