Thread: how to count if a cell value falls between two numbers
View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Ashish Mathur[_2_] Ashish Mathur[_2_] is offline
external usenet poster
  
Posts: 1,766
Default how to count if a cell value falls between two numbers
Hi,

=countif(A1:A5,"35")-countif(A1:A5,"<40")

--
Regards,

Ashish Mathur
Microsoft Excel MVP
www.ashishmathur.com

"Glenn" wrote in message
...
I tried to write a formula to count how often the value of a range of
cells
falls between two numbers. for example in the chart below:

row value
1 25
2 27
3 36
4 37
5 42

I tried the formula =countif(a1:a5,and(35,<40)) and my result was "0"
when
it should be "2".

Can anyone help correct my formula?

thanks

glenn
--
Glenn

Reply With QuoteReply With Quote