SumIf Help

[RoadKill]

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

 

[Barb Reinhardt]

Try this

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

 

[T. Valko]

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%))

 

[RoadKill]

Both of you guys rock. Thanks much.

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%))

 

[T. Valko]

You're welcome!

--
Biff
Microsoft Excel MVP

Both of you guys rock. Thanks much.