Counting populated cells (range) in one column, that fall between 2 (diff) values in another column

SnakeDoctor · #1 07-16-2024, 09:10 AM

Good morning!

I have a worksheet for managing components in individual modules. So, each module title is a 'locked' row followed by rows for each component of that module.

Module Titles are in column A
Component Numbers are in column C

I need to count the number of components of each module. I have been trying to write a formula to count the cells of column C that are 'between' two different values in column A.

I have painfully figured out basic counting formulas for other data in this worksheet but have not had to create 'count if between', 'ranges' or 'IF this, and this, then Count this' type formulas.

Can anyone help me out?

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Copying column to another column with deleting date due to blank cells	Sportsmen	Excel	3	04-18-2023 06:16 AM
display a change in column cells counting the number of months	oscarlimerick	Excel	4	03-14-2022 12:22 AM
Auto-Entering Values into a Column in a Table based on Value in Adjacent Column	nytvsh	Excel	2	12-06-2021 12:33 AM
Formula to check combinations of values in one column to find match from another column	kong1802	Excel	1	06-15-2018 05:26 AM
Shortcut to haven ascending values in row/column of cells	Straitsfan	Excel	1	08-09-2016 05:28 AM