Re: CountIFs with multiple criteria

I'm using the following code to count how many rows in the "Tracker" sheet match the given criteria
=COUNTIFS(Tracker!$I5:$I516,DATE(YEAR(TODAY()),MONTH(TODAY()),1),Tracker!$F5:$F516,">11:30",Tracker!$F5:$F516,"<12:00")

However as soon as i change the range "$i5:$i516" to include more cells. the formula stops working.

I've attatched the actual document i'm working on. Any help would be greatly apreciated.