Re: CountIFs with multiple criteria

**antiscripter** · 05-04-2011, 06:15 PM

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.

**daddylonglegs** · 05-04-2011, 07:03 PM

If you change 1 range you have to change the others to match, i.e. for counting up to row 1000 try

=COUNTIFS(Tracker!$I5:$I1000,DATE(YEAR(TODAY()),MONTH(TODAY()),1),Tracker!$F5:$F1000,">11:30",Tracker!$F5:$F1000,"<12:00")

Note that this part

DATE(YEAR(TODAY()),MONTH(TODAY()),1)

could be shortened to

=EOMONTH(TODAY(),-1)+1