SUM(IF greater/equal every other row

[Defaced]

Hopefully I will explain this well enough to understand outside my brain. I have 2 columns of shift times (Shift Start and Shift End) all on the even rows. Under their shifts is the row that has their Lunch break start/end times. I need to get an interval count of the number of people staffed, but when I used:

{=SUM(IF($A3>=$B$3:$B$100,IF($A3<$C$3:$C$100,1,0),0))}

It includes the lunch shifts and makes my counts inaccurate. Does anyone know of a way to only sum the even rows (shifts) and subtract the even rows (lunches) to get a true count?

 

[Defaced]

Got it figured out using COUNTIFS

=COUNTIFS('Schedule'!$A$1:$A$100, "<>" & 'Schedule'!$A$2, Schedule'!$C$1:$C$100, "<=" & A3,'Schedule'!$D$1:$D$100,">" & A3)-COUNTIFS('Schedule'!$A$1:$A$100,"=" & 'Schedule'!$A$2,'Schedule'!$C$1:$C$100,"<=" & A3,'Schedule'!$D$1:$D$100,">" & A3)