ExcelBanter - Countif number between x and y

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

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

- - Countif number between x and y (https://www.excelbanter.com/excel-programming/441641-countif-number-between-x-y.html)

Bill

Countif number between x and y

Have a column of figures and want to countif the value in cell falls between
x or y
That is countif(e:e, 5 or <10)

Jacob Skaria

Countif number between x and y

Hi Bill

Try

=COUNTIF(A:A,"5")-COUNTIF(A:A,"=10")

OR

=SUMPRODUCT((A1:A1005)*(A1:A100<10))

--
Jacob (MVP - Excel)

"Bill" wrote:

Have a column of figures and want to countif the value in cell falls between
x or y
That is countif(e:e, 5 or <10)

All times are GMT +1. The time now is 02:06 PM.