SumIf Help
 

Hello,

Here is my sumif presently: =SUM(IF(C5:C1000=20%, IF(C5:C1000<30%,1,0))).

What I would like is to add column B to it as well where it looks for a
particular Supervisor and then add together the amount of people between 20
and 29.99%. This is what I would like to add: B5:B1000="John Doe".

Is this possible with sumif or do I need to go another route?

Thank you

SumIf Help
 

Try this

=SUMPRODUCT(--(C5:C1000=20%),--(C5:C1000<30%),--(B5:B1000="John Doe"))
--
HTH,
Barb Reinhardt



"RoadKill" wrote:

Hello,

Here is my sumif presently: =SUM(IF(C5:C1000=20%, IF(C5:C1000<30%,1,0))).

What I would like is to add column B to it as well where it looks for a
particular Supervisor and then add together the amount of people between 20
and 29.99%. This is what I would like to add: B5:B1000="John Doe".

Is this possible with sumif or do I need to go another route?

Thank you

SumIf Help
 

Try this array formula:

=SUM((B5:B1000="John Doe")*(C5:C1000=20%)*(C5:C1000<30%))

Or, this non-array version:

=SUMPRODUCT(--(B5:B1000="John Doe"),--(C5:C1000=20%),--(C5:C1000<30%))


--
Biff
Microsoft Excel MVP


"RoadKill" wrote in message
...
Hello,

Here is my sumif presently: =SUM(IF(C5:C1000=20%, IF(C5:C1000<30%,1,0))).

What I would like is to add column B to it as well where it looks for a
particular Supervisor and then add together the amount of people between
20
and 29.99%. This is what I would like to add: B5:B1000="John Doe".

Is this possible with sumif or do I need to go another route?

Thank you

SumIf Help
 

Both of you guys rock. Thanks much.

"T. Valko" wrote:

Try this array formula:

=SUM((B5:B1000="John Doe")*(C5:C1000=20%)*(C5:C1000<30%))

Or, this non-array version:

=SUMPRODUCT(--(B5:B1000="John Doe"),--(C5:C1000=20%),--(C5:C1000<30%))


--
Biff
Microsoft Excel MVP


"RoadKill" wrote in message
...
Hello,

Here is my sumif presently: =SUM(IF(C5:C1000=20%, IF(C5:C1000<30%,1,0))).

What I would like is to add column B to it as well where it looks for a
particular Supervisor and then add together the amount of people between
20
and 29.99%. This is what I would like to add: B5:B1000="John Doe".

Is this possible with sumif or do I need to go another route?

Thank you

SumIf Help
 

You're welcome!

--
Biff
Microsoft Excel MVP


"RoadKill" wrote in message
...
Both of you guys rock. Thanks much.

"T. Valko" wrote:

Try this array formula:

=SUM((B5:B1000="John Doe")*(C5:C1000=20%)*(C5:C1000<30%))

Or, this non-array version:

=SUMPRODUCT(--(B5:B1000="John Doe"),--(C5:C1000=20%),--(C5:C1000<30%))


--
Biff
Microsoft Excel MVP


"RoadKill" wrote in message
...
Hello,

Here is my sumif presently: =SUM(IF(C5:C1000=20%,
IF(C5:C1000<30%,1,0))).

What I would like is to add column B to it as well where it looks for a
particular Supervisor and then add together the amount of people
between
20
and 29.99%. This is what I would like to add: B5:B1000="John Doe".

Is this possible with sumif or do I need to go another route?

Thank you