Daily average

Muthukrishnan V

Board Regular
Joined
May 29, 2008
Messages
179
Office Version
  1. 365
Platform
  1. Windows
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
 

Some videos you may like

Excel Facts

Last used cell?
Press Ctrl+End to move to what Excel thinks is the last used cell.

Watch MrExcel Video

Forum statistics

Threads
1,114,323
Messages
5,547,256
Members
410,782
Latest member
Colart
Top