Counting populated cells (range) in one column, that fall between 2 (diff) values in another column
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?
|