I have a timesheet that include staff of different disciplines and their hours. I am count the amount of staff in each day by purely using function to count any that begin with 0 - Function used: =COUNTIF(B14:B54,"0*") This returns the total of 10 which is correct. This however is split into 4 manager and 6 staff and would like to split this by using same count but for cells that those disciplines appear. For example I tried;
=COUNTIF(B18,B27,B28,B40,B48,"0*") but this didn't work.

Can someone tell me how I select random cells within same column. The aim is to have total number of managers and staff in each day of which I can then add conditional formatting to when falls below required level.

Any advice would be gratefully received.