Swamp Thing
Active Member
- Joined
- Aug 16, 2002
- Messages
- 313
How can one use COUNTIF with a combination of two or more criteria (using OR, AND etc)? For example:
=COUNTIF(A1:A100 , "AND( >10 , <20 ) " )
does not work, but there must be a way to count the values that lie between 10 and 20.
=COUNTIF(A1:A100 , "AND( >10 , <20 ) " )
does not work, but there must be a way to count the values that lie between 10 and 20.