Results 1 to 2 of 2

Thread: Incremental Average

  1. #1

    Question Incremental Average



    Register for a FREE account, and/
    or Log in to avoid these ads!

    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.

  2. #2
    Super Moderator NBVC's Avatar
    Join Date
    May 2011
    Location
    Mississauga, Canada
    Posts
    1,489
    Articles
    0
    Excel Version
    Excel 2016
    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


Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •