View Single Post
  #2   Report Post  
Spencer101 Spencer101 is offline
Senior Member
 
Posts: 663
Default

Quote:
Originally Posted by Chris Urban View Post
I have 28 ranges of values in column E (lower limit) and column F (upper limit). I need to count the value in column B is the value in column A is within the range (column E to column F).

The goal is to be able to easily change the upper and lower limits in columns E and F.

Attached is a PDF of file. The list in colums A and B go down much futher. Thanks in adance for your help.

Chris
Are you looking to count the number of instances where the value in A falls within the range (E-F), or sum the values in B when the value in A falls within the range?