If and Or statement

M

Matt

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?
 
B

Bob Phillips

=SUM(IF(A1:A4>0,A1:A4)

which is an array formula, so commit with Ctrl-Shift-Enter.
 
R

Ron Rosenfeld

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?
Click to expand...

=SUMIF(A1:A3,">0")




--ron
 
R

RagDyeR

How about plain, old:

=SUMIF(A1:A4,">0")

???
--

HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================


=SUM(IF(A1:A4>0,A1:A4)

which is an array formula, so commit with Ctrl-Shift-Enter.
 
B

Bob Phillips

Oh don't be so boring :)

--
HTH

Bob Phillips

RagDyeR said:
How about plain, old:

=SUMIF(A1:A4,">0")

???
--

HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================


=SUM(IF(A1:A4>0,A1:A4)

which is an array formula, so commit with Ctrl-Shift-Enter.

--
HTH

Bob Phillips

can
Click to expand...
 
Top