Count Column B if Column A is within a multiple specificed ranges
I have 28 ranges of values in column E (lower limit) and column F (upper limit). I need to sum the value in column B if 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
Last edited by Chris Urban : April 18th 12 at 05:09 PM
|