Need to count number of entered chapters (Rows) for each Title
Greetings!
We have numerous Manuals we need to review chapter-by-chapter and track the progress of the review of each Manual.
I am separating each Manual by entering only the titles in Column A, each title in its own row, and then entering each Chapter name in a separate row in Column B. Effectively separating each book title (Column A) using the book chapters (Column B).
What I need is to count the number rows entered between each Title, so I have a value to calculate the percentage of completed chapter reviews from.
Can anyone help me out with this?
I have attached a copy of the Workbook, I was trying calculations in Columns L & M to hide the totals when I hide the columns. And I will add the percentage complete in Column D of each Title Row.
|