Count If Formula Three Criteria

[mdonovan890]

I am trying to create a formula that will count the number of results that fall within a certain range with text. For example all Canine results that are greater than 1 but less than 7
the formula I am looking for would return a value of 2 in Cell H2.

The formula I have returns an error: =COUNTIFS(D1:D1000,"Canine", B1:B1000,">="&1,B1:B10000,">"&7)

 

[Jonmo1]

Close

=COUNTIFS(D1:D1000,"Canine", B1:B1000,">="&1,B1:B10000,">"&7)
Probably should be
=COUNTIFS(D1:D1000,"Canine", B1:B1000,">="&1,B1:B10000,"<"&7)

 

[Tetra201]

And the ranges should be of the same size.

 

[Jonmo1]

And the ranges should be of the same size.

Good catch, I didn't notice that.