SumIf Help

R

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
 
B

Barb Reinhardt

Try this

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

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

RoadKill

Both of you guys rock. Thanks much.

T. Valko said:
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%))
Click to expand...
 
Top