| Home |
| Search |
| Today's Posts |
|
|
|
#1
|
|||
|
|||
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 |
|
#2
|
|||
|
|||
|
Quote:
|
|
#3
|
|||
|
|||
|
Quote:
|
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Multiple Named Ranges in the Same Column | Excel Worksheet Functions | |||
| Sum Multiple Ranges in the Same Column | Excel Discussion (Misc queries) | |||
| Multiple Ranges in 1 Column using VBA | Excel Discussion (Misc queries) | |||
| Count rows that match criteria in 2 different column cell ranges | New Users to Excel | |||
| How do I count cells in a column of dates between date ranges? | Excel Worksheet Functions | |||
Hybrid Mode
