non overlapping average

[fabiogiallo]

Good evening all,

I have a column with results with gaps (blank cells) in between and i need to calculate in another column a rolling average (non overlapping) every 6 results (as per attached image).
the blank cells could be anywhere, always changing.
Any suggestion about formula or vba code to use?

Thank you in advance.

r

 

[Joe4]

Where exactly are these results going to show up?
What if the number of records is not an exact multiple of 6? What happens to the last few records in that case?

 

[Eric W]

Maybe:

Book1
	A	B	C
1	Results		6 number averages
2	70		52.83333
3	56		62.33333
4	32		34.5
5			#NUM!
6	45		#NUM!
7	56		#NUM!
8
9	58
10
11	57
12	65
13	66
14
15
16	55
17
18	67
19	64
20
21	74
22	56
23
24
25
26	11
27	19
28
29	23
30
31	24
32
33
34	44
35	45
36	46
Sheet2

Cell Formulas
Range	Formula
C2:C7	C2	=AVERAGE(INDEX(A:A,AGGREGATE(15,6,ROW($A$2:$A$100)/($A$2:$A$100<>""),ROWS($C$2:$C2)*6-5)):INDEX(A:A,AGGREGATE(15,6,ROW($A$2:$A$100)/($A$2:$A$100<>""),ROWS($C$2:$C2)*6)))