View Single Post
  #1   Report Post  
Chris Urban Chris Urban is offline
Junior Member
 
Posts: 2
Default 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
Attached Images
File Type: pdf Excel Banter.pdf (8.4 KB, 87 views)

Last edited by Chris Urban : April 18th 12 at 05:09 PM