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

James

Active Member
Joined
Feb 17, 2002
Messages
327
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
 

Excel Facts

How to change case of text in Excel?
Use =UPPER() for upper case, =LOWER() for lower case, and =PROPER() for proper case. PROPER won't capitalize second c in Mccartney
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
 
Upvote 0
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)
 
Upvote 0

Forum statistics

Threads
1,213,494
Messages
6,113,986
Members
448,538
Latest member
alex78

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top