Count Column B if Column A is within a multiple specificed ranges

[Chris Urban]

I have 28 ranges of values in column E (lower limit) and column F (uppe
limit). I need to count the value in column B is the value in column
is within the range (column E to column F).

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

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

Chri

+-------------------------------------------------------------------
|Filename: Excel Banter.pdf
|Download: http://www.excelbanter.com/attachment.php?attachmentid=328
+-------------------------------------------------------------------

 

[Spencer101]

I have 28 ranges of values in column E (lower limit) and column F (uppe
limit). I need to count the value in column B is the value in column
is within the range (column E to column F).

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

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

Chris

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

+-------------------------------------------------------------------
+-------------------------------------------------------------------

 

[Chris Urban]

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

Sum the values in B when the value in A falls within the range

+-------------------------------------------------------------------
+-------------------------------------------------------------------