I don't understand.
You wrote: "What I need is to count the number of rows entered between each Title, so I have a value to calculate the percentage of completed chapter reviews from."

And in the file you entered the data so that each title has exactly 10 rows.
Does each title always have 10 towers? If so, why manually create 10 NAMEs and manually enter formulas 10 times in M7, M18, M29, ...?
You simply always have 10 rows for each title.

Besides, if you have 50 titles, do you also manually create NAMEs 50 times and enter formulas 50 times in columns M and O (50*2 = 100 times)?

If the number of rows between titles in column B changes for each title, then:
1. If you want to count the number of empty and non-empty rows between titles, then:

Formula in M7 (file in #6)

and copy down to the last title line

2. If you want to count the number of non-empty lines between titles, the formula is given in post #2.

In this case, the formula for M7


I think you want point 2.
----------------
Formula for O7 (note: "Approved" is in column E - file in #6)

-------------------
Note:
1. If the formula causes an error, try changing ";" to ","
2. There must be at least 1 non-empty cell after the last title in column B. In the file with #6, cell B130 <> "". If there are only empty cells from B122 down, you need to enter B122 = "hic hic hic" or whatever

Hey, Batman1! Thanks for helping out with this, I really appreciate it

This example is strictly the template (and example) for this workbook. I created 10 blank rows under each Title row simply for data uniformity during testing and then blanked each row to create a sanitized example to post here.

The number of titles in Column B will (only) increase depending on the number of manuals created as the project moves forward.

The number, composition, and details of chapters for each manual created (Columns C~H) should (only) increase depending on the number of manual chapters created as the project moves forward.

e.g., There can be Manuals with anywhere from many to just a few Chapters.

Again, I had been looking for a solution to this for a while, and there are now several workbooks the company wanted created using the same 'titled blocks of data' method.

I will try this with your formulas now!

Thanks, again! I'll let you know how it goes!