Hello =) Need a wee bit of advice on Countif/filtering

Hi All! I need a little help in a countif situation =)
I've tried to use countif but I keep stuffing it up =/

PROBLEM 1

I have attached a file called Excel problem 1.

We have a roster (sheet1 in the attachment) where we are trying to find a way to count the cells highlighted in red in a column that have the same code name in them. Note there are 3 places that have been numbered.

For example, on any particular day we need a certain amount of people to be in certain groups (the red cells). These groups are P10,P22 AND P31 which are highlighted in red next to each employees name.

e.g.

- P31 needs at least 2 people
- p10 needs at least 3 people
- p22 needs at least 1 person
-p50 needs at least 2 people
- C needs at least 3 people

So it would be great to see how many people there are in each Red group each day. The roster is usually alot bigger but i have shrunk it down.

I have created a desired outcome TAB to show sort of what I was hoping to achieve.


SECOND SCENARIO.

I have attached a second attachment called excel problem 2

Mostly the same as the first problem but with a twist if possible.
If these Places (place 1 place 2 and place 3) were to be separated into seperate tags. would it still be easy to withdraw this information ?



Thanks so much guys! if you have any suggestions that would be amazing. I love excel and keen to learn more =)

Hi Flameretired,

Thanks so much for your advice! hilariously my work computer completely died and I have to wait for a new one before I can finally implement your recommendations but should have the new computer on Monday and will let you know how I go =)

Hi Flameretired,

Thanks so much for your advice! hilariously my work computer completely died and I have to wait for a new one before I can finally implement your recommendations but should have the new computer on Monday and will let you know how I go =)

Hi Flame! it works PERFECTLY =) thanks so much.

Just a quick question since theres a small detail I failed to mention, the groups (e.g. p10, p22) arent limited to the "place one", "Place two", "place three". These just mean the locations that staff are based in but any staff from any "place" can be on any team. e.g. a p10 group might have 1 staff member from each "place". Do i just tack on the 3 excel ranges one after the other somehow? I had a go but it didnt accept it haha. This question is for both scenarios (excel problem 1 and 2)

thanks in advance~!

thanks flame =) i'll keep trying. good to know its possible


Cheers!