how do i count cells with values in a certain range ?

[Capt. Trevor Bailey]

I want to count the number of times in a given range in an Excel worksheet
that data occur between two values - e.g. how many cells are between 1001
and 1500 ?
It seems that COUNTIF only allows single values and COUNTA requires whole
numbers.

 

[Dave O]

This formula will do it:
=SUMPRODUCT(--(A1:A13>=1001),--(A1:A13<=1500))
If you use it, make sure to adjust the ranges to fit your data and that
the "greater than or equal to" and "less than or equal to" operators
fit your requirements.

 

[David Biddulph]

I want to count the number of times in a given range in an Excel worksheet
that data occur between two values - e.g. how many cells are between
1001
and 1500 ?
It seems that COUNTIF only allows single values and COUNTA requires whole
numbers.

=COUNTIF(range,">1001")-COUNTIF(range,">=1500")

Adjust depending on exactly what you want to do with the boundary values
(hence what you mean by "between").

 

[CLR]

=COUNTIF(A:A,"<=1500")-COUNTIF(A:A,"<1001")

Vaya con Dios,
Chuck, CABGx3