Thank you for the reply, however, the attachment you added did not open, and I am not quite sure I understand fully. I changed the A32:A34 and removed the "On" part to make sure the times match. I changed the formula in C32 from -COUNTIF(C4:C19, "7a-3p") to =COUNTIF(C4:C19,"7a-3p"&$A32&"3p-11p") and its still not counting correctly in C32 and C33 when i enter 7a-3pm and 3p-11p it still only adds it to C33 and removes it from C32. Did I enter the wrong formula