Thread: how do i count cells with values in a certain range ?
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
David Biddulph David Biddulph is offline
external usenet poster
  
Posts: 618
Default 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


Reply With QuoteReply With Quote