Currently using COUNTIFS but i have another criteria

[eechristaylor]

I am currently using the following formula to look at data on another sheet and count the number in the range I have specified in column a and column B:

=COUNTIFS('T1-drop'!$F:$F,"<=" & B5,'T1-drop'!$F:$F,">"& A5)

I now have another criteria from the other sheet, I only want to count if column B on the T1-Drop sheet is a 1?

Greatly appreciate any help in determining this.

 

[RoryA]

You can just add that in the same way as the others:

=COUNTIFS('T1-drop'!$F:$F,"<=" & B5,'T1-drop'!$F:$F,">"& A5,'T1-drop'!$B:$B,1)