Need to count number of entered chapters (Rows) for each Title

SnakeDoctor · #1 02-13-2025, 09:18 AM

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.

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
count formula to count based on multiple criteria and return unique rows	Sphinxakop	Excel	0	02-01-2023 12:18 PM
Getting the Count formula to count all rows	Jennifer Murphy	Word Tables	11	08-23-2016 09:37 PM
How to number chapters and sub-chapters in a few clicks?	Icelandic_Boy	Word	1	05-24-2016 11:33 AM
Add chapters, section and subsection number on footer	guicalabria	Word	15	06-30-2015 05:23 AM
How to create a table with a number of line depending a number entered by user	Cellendhyll	Word Tables	3	07-10-2014 05:49 AM