mdonovan890
New Member
- Joined
- Dec 22, 2016
- Messages
- 24
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)
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)

Last edited: