Oh don't be so boring :-)
--
HTH
Bob Phillips
"RagDyeR" wrote in message
...
How about plain, old:
=SUMIF(A1:A4,"0")
???
--
HTH,
RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================
"Bob Phillips" wrote in message
...
=SUM(IF(A1:A40,A1:A4)
which is an array formula, so commit with Ctrl-Shift-Enter.
--
HTH
Bob Phillips
"Matt" wrote in message
...
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?
|