Hi and thanks for any help it is truly appreciated !

Ok so I am currently using a formula to count the number of cells in a range as below:

Also

Now my issue if that some cells with WOW as the value have an adjacent cell to the immediate left which is where the finish time would normally go and I would like to exclude these from the count, as they are counted in a different way.

I've searched around and found some SUMIF examples but I'm struggling to get this to work !

I know the over all count is ok as there is a discrepancy of 21 in 2 separate parts of the table which means 21 night shifts have been counted twice !

Again any help is truly appreciated I'm absolutely shattered and probably overlooking something simple but for the life of me I cant work it out and likely to headbut the keyboard shortly LOL

James