Sumif Formula Help - Sum between ""'s

[Alphacsulb]

I'm looking for a way to auto calculate sums in column C. The parameter is to count the numbers between the empty cells in row B. Right now I have to manually sum up the counts as the example shows.

Any leads would be appreciated.

Excel Workbook
	A	B	C
10	a	1
11	b	1
12	c	1
13	d	1
14			4
15	a	1
16	b	1
17	c	1
18			3
19	a	1
20	a	1
21			2
22	b	1
23	v	1
24	s	1
25	d	1
26	d	1
27			5
Sheet1

 

[VoG]

Have you tried Data > Subtotals based upon column A?