SUMIFS issues

Hi all, I'm struggling to get a SUMIFS formula to work, it's been a little while since I've used these so I'm sure I've missed something obvious

I've attached a workbook showing what I'm trying achieve, can someone explain to me where I'm going wrong please?

The jist basically is I want to add the range per set by either day or night (as indicated in one of the columns), but it won't come back with an answer - I'm guessing my ranges are incorrect?

Any help would be greatly appreciated.

Thanks.