ExcelBanter - Countif Function

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - Countif Function (https://www.excelbanter.com/excel-programming/289553-countif-function.html)

Bill R.

Countif Function

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

Roger Govier[_9_]

Countif Function

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

--
Regards
Roger Govier
"Bill R." wrote in message
...
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

All times are GMT +1. The time now is 10:32 AM.