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
|