Countif Function

B

Bill R.

Is it possible in a single COUNTIF instruction to check for more than 1
*criteria*
Example: I want to know how many cells in A1:H100 hold a value of between 5
and 20.

TIA
Bill
 
R

Roger Govier

Hi Bill
The answer is no.
Instead use
=COUNTIF(A1:H100,"<="&20)-COUNTIF(A1:H100,"<"&5)
 
Top