Number Look Ups

[jorymf8]

Hello, I would like to know how I could look up numerical values that fall within a certain range in my spreadsheet without looking at each individual value by myself. In column A I have random numbers, and I would like to look up all values that are 15<number<20. Is there an IF statement or VBA I could use to accomplish this? Thanks!

 

[bluefish44]

If you are looking to see how many lie between these two numbers try something like this

=sum((a1:a500>15)*(a1:a500<20))

use CTRL + SHIFT + ENTER