Thread: SumIf Help
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
roadkill roadkill is offline
external usenet poster
 
Posts: 173
Default 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