View original (French)

Cumulative average with Excel 2007

Solved
fuveau21 Posted messages 32 Status Member -  
fuveau21 Posted messages 32 Status Member -
Hello everyone
I would like to automatically calculate a "cumulative" average of numbers from several cells.
Let me explain:
if I have 2 cells, I want to calculate the average and write it in another cell (so far, I managed to do that)
if I have 3 cells, I want to calculate the average and write it in another cell (different from the one above)
etc...
Of course, I could write the average formula by adding each new cell address, but after a certain number it becomes tedious.
Is there a way to write a formula that can automatically increment a new cell to the previous ones and calculate the new average using the handle at the bottom right?
I am not sure this exists and I am asking just in case.
Thank you in advance for your help.
fuveau21

Configuration: Windows / Firefox 59.0

2 answers

  1.
    Vaucluse Posted messages 27336 Registration date   Status Contributor Last intervention   6 453
     
    Hello
    what exactly is your problem?
    because if we take that literally, to adapt
    your value list starts in A2 in B2 the formula:
    =AVERAGE($B$2:B2) dragged down will give you the average of the values from the 1st row to the row where it is located
    provided that you place the $ signs correctly on the 1st B2 so that it remains fixed and not on the second one so that it evolves when dragging
    best regards,

    --
    The quality of the response mainly depends on the clarity of the question, thank you!
    0