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

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - Count Column B if Column A is within a multiple specificed ranges (https://www.excelbanter.com/excel-worksheet-functions/445808-count-column-b-if-column-within-multiple-specificed-ranges.html)

Chris Urban

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

1 Attachment(s)

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

Spencer101

Quote:

Originally Posted by Chris Urban (Post 1600923)

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?

Chris Urban

Quote:

Originally Posted by Spencer101 (Post 1600924)

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?

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

All times are GMT +1. The time now is 02:49 PM.