Countif if the value falls between 2 other values

L

les8

Need to count values that fall between two limits: for example
462
997
569
122
Need to count values between 300 and 600.
I can do if my desired value is over or under a target, but not within a
range.
Any help would be greatly appreciated.
Thanks.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Finding the right style field in VBA 0
COUNTIFS (the numbers in a column, when subtracted meet a certain criteria) 1
Finding the proper style field and the numbered paragraph value within the style 0
Show value from one cell in another cell if today falls between a date range 5
Count if data falls within a range AND that has a certain criteria 1
how to count if a cell value falls between two numbers 4
countif value falls in a range of possible values 1
Excel formula to test a value BETWEEN 2 values? 8

Top