count characters up to a certain point

[Peter1973]

I am trying to get a formula to look in A1:A1000 from A1 downwards and coutn how many "x" there are until it gets to a "y".

hope this is clear any help appreciated.

 

[Special-K99]

Just one set of x's then a y?
Or multiple sets of x's?
e.g.


x
x
x
y

x
x
x
x
x
y

 

[Peter1973]

Multiple like the list you have put.

 

[Peter_SSs]

Multiple like the list you have put.

Something like this then, copied down?

Book1
	A	B
1	Data	Count
2	x
3	x
4	x
5	y	3
6
7	x
8	x
9	x
10	x
11	y	4
12	y	0
13	x
14	y	1
15	x
Count x

Cell Formulas
Range	Formula
B2	=IF(A2="y",COUNTIF(A$2:A2,"x")-SUM(B$1:B1),"")