Need help with Countif function

Hello everyone! Merry Christmas!

I am a complete newbie and would like to ask for help with my worksheet. I am trying to count all positions according to the shift (days - tw, evenings - tw, or in office). I am able to get the correct countif function when all the data are arranged vertically, however, mine has data in multiple columns and i cant figure out how i can do the countif with multiple parameters and multiple columns. The sample data attached has the explanation on what summary i would like to have. Really appreciate if you could help me with my file.

Thank you so much in advance!

Originally Posted by Glenn Kennedy

Forget the last two posts. See formulae in sheet. Different shading = different formulae, all based on SUMPRODUCT as previously.

Thank you so much! Sorry I wasnt able to see your earlier messages, but you still figured it ALL out! This is my first time posting by the way. and I am so glad that I found this site.

You all ROCK!

Originally Posted by Glenn Kennedy

If you change them to VL-Evenings, etc, etc, then it's easy...

Yes, I'll have to change this later as well. I was just thinking it will be redundant so i will try to figure it out myself since you basically solved my main problem. Thanks again!