Incremental Average

Ashurk77

New member
Joined
Jul 9, 2013
Messages
11
Reaction score
0
Points
0
Hi every one,

I want to find incremental average

My cell numbers are

AG4

AG4,AG13

AG4,AG13,AG22

AG4,AG13,AG22,AG31

and so on..

(In incremental of 9)

Thanks in advance.
 
Try:

Code:
=SUMPRODUCT((MOD(ROW($AG$1:INDEX($AG:$AG,9*(ROWS($AG$1:AG1)-1)+4))-ROW($AG$1)-3,9)=0)+0,$AG$1:INDEX($AG:$AG,9*(ROWS($AG$1:AG1)-1)+4))/SUMPRODUCT((MOD(ROW($AG$1:INDEX($AG:$AG,9*(ROWS($AG$1:AG1)-1)+4))-ROW($AG$1)-3,9)=0)+0,($AG$1:INDEX($AG:$AG,9*(ROWS($AG$1:AG1)-1)+4)>0)+0)

copied down
 
Back
Top