Help counting nonblank cells

[theScragg]

I have an issue trying to get a formula to count the number of nonblank cells between two words in the same column. Here is a sample of the data I'm working with.

Eg.
Dates
Oct 12
Oct 13
[blank]
[blank]
[blank]
Dates
Oct 7
[blank]
[blank]
Dates

I am trying to use a formula to tell me how many dates are for each account in column that contains hundreds of accounts. I have a formula that can tell me the number of lines between each instance of the word "Dates" but since the intervals are not the same between the "Dates" (due to other information elsewhere) this information isn't helpful. This is the formula I was using: =IF($O11="Date(s)", MATCH("Date(s)",$O12:$O30,0),"")

I think I need something like COUNTA, COUNTIF or ISBLANK, but I'm not sure how to implement it to work. When I've tried, the output is always just 1, which means its only counting how many "Dates" exist between the starting word and the word it's counting.

 

[Scott Huish]

Is this what you need?

Book1.xlsx
	A	B
1	Dates	2
2	12-Oct
3	13-Oct
4
5
6
7	Dates	1
8	7-Oct
9
10
11	Dates	0
Sheet1

Cell Formulas
Range	Formula
B1:B11	B1	=IF(A1="Dates",COUNTA(A2:INDEX(A2:$A$5500,MATCH("Dates",A2:$A$5500,0)))-1,"")

 

[theScragg]

Thank you so much. I'm going to figure out where my logic went wrong based on your formula