Alansidman,

Thank you for the assist! Here is an example. I need to count the (non-blank) cells in the 'WORK CARD NUMBER' column (C), that follow the Module Title in the 'MODULE NUMBER ABD PREFIX' column (A).

So, how many Work Cards are in Module 1-GP, how many Work Cards are in Module 2-PD, etc...

Attached Files

EXAMPLE.xlsx (101.4 KB, 6 views)