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.
|