Countif Function

  • Thread starter Thread starter Bill R.
  • Start date Start date
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
 
Hi Bill
The answer is no.
Instead use
=COUNTIF(A1:H100,"<="&20)-COUNTIF(A1:H100,"<"&5)
 
Back
Top