Microsoft Office Forums - View Single Post - [Solved] Need to count number of entered chapters (Rows) for each Title

Thread: [Solved] Need to count number of entered chapters (Rows) for each Title

View Single Post

Old

02-13-2025, 01:49 PM

batman1

batman1 is offline

batman1 uses Windows 11

Windows 11 batman1 uses Office 2013

batman1 uses Office 2013

Office 2013

Advanced Beginner

Join Date: Jan 2025

Posts: 56

batman1 is on a distinguished road

Default

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)))

Reply With Quote