Counting Question

[avisherrman]

I have a table with 2 columns:
Column A is called chapter title, Column B is a time in minutes:seconds
As an example there are 10 Rows in my sheet. Each row has a time value in column B. BUT not each row has a value in Column A. Ex: Chapter one could have 3 times, Chapter 2 could have 4 and Chapter 3 Could have 3.
How could I easily count the number of Chapters AND count the number of times in each chapter.

Thanks in advance

[Richard Buttrey]

Please upload a workbook or a representative cut down copy, anonymised if necessary. It is always easier to advise if we can see your request in its context.

Show a before and after situation and if it's not blindingly obvious how you have arrived at your results some explanatory notes as well.

[avisherrman]

Thank you
Attached is an image of the sheet.Picture 1.png

[Pepe Le Mokko]

Please post a sheet, not a picture - Thx

[avisherrman]

untitled.xlsx

Thanks Again, here is the file

[Richard Buttrey]

Hi,

The chapter count is simply
=COUNTIF(B:B,"Chapter *")-1

For the number of times in each chapter enter in D2
=IF(AND(B2<>"",B3=""),1,1+D1)

Use a conditional 'formula is' format on D2
=D2<D3
and set the font colour to white and copy D2 down

Regards