Home » Forums » Open Source Learning Center » Question and Answer

Incrimental Average

Submitted by Ashurk77 on 9 July, 2013 - 17:50

Hi Everyone,

I want to find average of cells

Ag4

Ag4,AG13

Ag4,AG13,Ag22

and so on...
(in incremental of 9)

Thanks in Advance

‹ Macros for Working with Data Excel Macro ›
»

Incremental average

Submitted by Jeanbar on 25 July, 2013 - 13:27.

Ashurk,

Please have a look at this example : https://app.box.com/s/ycg335mqg47jmpna0p88

The area of numbers to calculate the average from is H4:H158

1°) The first method starts to calculate the cumulative sum of the entries, based on their references : the INDIRECT() function fetches their values.
2°) The second method is using a named range, H4:H158 being called T_VAL. The average is calculated in cell F4 (cse formula). You just need to drag it down.

»