Find average of a value occurring consecutively

[worldCurrencies]

I want to find the average of something occurring consecutively. For example, in Column A, I would have the array: {1,1,1,0,0,0,1,1,1,1,0,0,1,0}. I want to find that 1 occurred consecutively 3 times, and every time it occurred consecutively, it averaged to be consecutive for 2.6. I found this from (3+4+1) / 3.

How would I find this in excel?

 

[Eric W]

If you're just dealing with 1s and 0s, try:

Book3
	A	B
1	1	2.666667
2	1
3	1
4	0
5	0
6	0
7	1
8	1
9	1
10	1
11	0
12	0
13	1
14	0
Sheet19

Cell Formulas
Range	Formula
B1	B1	=LET(a,FREQUENCY(IF(A1:A14>0,ROW(A1:A14)),IF(A1:A14=0,ROW(A1:A14))),AVERAGE(FILTER(a,a>0)))