Daily average

[Muthukrishnan V]

Office 365

Average on Daily basis

A B C
DATE AMOUNT DAILY AVERAGE
3 22-03-2020 5800 5800 (5800/1)
4 23-03-2020 1620 3710 (5800+1620)/2
5 24-03-2020 22000 9540 (5800+1620+22000)/3
6 25-03-2020 110 7383 (5800+1620+22000+110)/4

I request formula for column C that calculates daily average progressively.

Thanking you

 

[gaz_chops]

Try

=SUM($B$2:B2)/ROW(A1)

 

[Muthukrishnan V]

Thank you Sir

 

[gaz_chops]

You're welcome.