Thanks:  0
Likes:  0

1. 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

2. 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

3. 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)

## User Tag List

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts
•