Hi,
Earlier today i thought i had it:
=SumIF(O7:O2000,">0",S7:S2000) But the problem is it works just like it's written as
it never quits counting
What i really need is to sum between certain
rows, and without a defined range i.e.
O7>1
O8>1
O9=0
Q6=S7:S9(Total)
O11>1
O12=0
O13>1
O14>1
Q10=S11:S14(Total)
So as you can see without a defined range
i'm at a loss on how to control the total
any further help on this subject would be
very much appreciated
Thanks,Jim
Earlier today i thought i had it:
=SumIF(O7:O2000,">0",S7:S2000) But the problem is it works just like it's written as
it never quits counting
What i really need is to sum between certain
rows, and without a defined range i.e.
O7>1
O8>1
O9=0
Q6=S7:S9(Total)
O11>1
O12=0
O13>1
O14>1
Q10=S11:S14(Total)
So as you can see without a defined range
i'm at a loss on how to control the total
any further help on this subject would be
very much appreciated
Thanks,Jim