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

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.

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

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.

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

"Capt. Trevor Bailey" <Capt. Trevor wrote
in message ...
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").
--
David Biddulph

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

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

Vaya con Dios,
Chuck, CABGx3




"Capt. Trevor Bailey" wrote:

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.