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

Format cells as currency
Select range and press Ctrl+Shift+4 to format cells as currency. (Shift 4 is the $ sign).

Watch MrExcel Video

Forum statistics

Threads
1,114,111
Messages
5,546,005
Members
410,720
Latest member
SSL
Top