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

Reply With QuoteReply With Quote