CountIf Multiple functions

I am trying to find an easier way for the below formula.

1. Going down Column C I have different scheduled positions
2. Going across the Rows I have days 1 through 31
3. So Cell C5 is the 1st day of the month, D5 2nd day of the month and so on.
4. Each day is required 3 shifts of 8 hours for a total of 24 hours so the default in all the cells is 24
5. A penalty is held against us for any shift (8 hours) that is not completed 100%
6. 1 Point for any eight hour shift not fully completed so if we only completed 16 hours we would get 1 point penality, anything less than 8 hours would be 2 points and zero hours would be 3 points.

Also some of the people doing the data entry will use the space bar to clear the field instead of deleting it.
The below formula works but I feel like there should be an easier way.

Also I have some positions that are only 16 hours a day and some that are only 8 hours a day.


##=COUNTIF(C5:AG5,"<=8")+COUNTIF(C5:AG5,"<=16")+COUNTIF(C5:AG5,"")+COUNTIF(C5:AG5,"")+COUNTIF(C5:AG5,"")+COUNTIF(C5:AG5," ")+COUNTIF(C5:AG5," ")+COUNTIF(C5:AG5," ")##

Ok, I think I have attached the file.

It was the only way I knew to get three counts if the cell was blank. As an example if the cell calls for 24 hours and we did zero hours the cell would be blank and the multiple formula strings end up counted three times, 1once for each 8 hour shift.

Again the 24 = 3 shifts of 8 For each 8 hour period we do not fill it counts as 1 point. An empty cell would need to be counted as 3 points.

Keep in mind, I am NOT considered an experienced user of formulas so I'm sure there is a better way, that is why I posted the question.

Some positions (rows) are 7 days a week and some are Monday through Friday

Yes they are, I have it working with the posted formula. I was just trying to see if there is a cleaner way of doing it. I have 5 other locations with schedules that are close but vary in hours, so I am trying to find the best way to do it.