More on SumIf........Totals

[James]

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

[Jack in the UK]

Hi James

Stick to the same feeds that is add to your original feed earlier today - this board SHOULD but it top of the board so people will read and re read your posts else we all get confused...

Sorry mate i sit hours just like you and many others and ive lost where i was with your post.... im not have gos or moaning JUST want the best responce for YOU so you get the best poss help out there,

We could have two posts all flying about.

Im sure you understand - i not picking faults just in case you did not realise.

Take care friend
Rdgs
==========
Jack

[Mark W.]

On 2002-02-18 14:51, James wrote:
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

James, take a look at my response to your original posting...

=SUMIF(O7:O2000,"<>",S7:S2000)