Running average?

[horsefish01]

Hi,

How do I do so that the average here is correct every month? according to how many months has passed.. as when Januar is filled its 15%/1

..but when there is data in february it needs to be 15%+data/2

Mappe2.xlsx

[6StringJazzer]

Put this formula in N5:

Please Login or Register  to view this content.

However, beware the dangers of averaging percentages. Averaging may not give the results you want, depending on how you calculate the percentages.