View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc
CLR CLR is offline
external usenet poster
 
Posts: 1,998
Default 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.