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

		Microsoft Office Forums > Microsoft Excel > Excel
Need to count number of entered chapters (Rows) for each Title

02-13-2025, 01:49 PM

batman1

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

Office 2013

Advanced Beginner

Join Date: Jan 2025

Posts: 57

I don't know English and I don't know if I understand correctly. Do you want L7 = 13?

If so, the formula for L7, change ";" to "," if necessary

Code:

=IF(B7="";"";COUNTA(C8:INDEX(C8:C$1000;MATCH("*";B8:B$1000;0)-1;0)))

Thread Tools
Show Printable Version Email this Page
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

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

Other Forums: Access Forums

All times are GMT -7. The time now is 03:21 AM.