newbie_excel
New Member
- Joined
- Feb 17, 2007
- Messages
- 23
Hi my sheet looks like this:
A B C
31-May 35 94
01-Jun 38 87
02-Jun 65 89
03-Jun 56 98
04-Jun 45 78
05-Jun 34 65
06-Jun 48 93
07-Jun 29 72
08-Jun 55 87
Then in colums D and E I have more values like in columns B and C.
In column F I have the sum of rows B to E.
I'd like a formula which will calculate the average sum of these rows in the last five days, with the average changing everyday as more rows are added.
A B C
31-May 35 94
01-Jun 38 87
02-Jun 65 89
03-Jun 56 98
04-Jun 45 78
05-Jun 34 65
06-Jun 48 93
07-Jun 29 72
08-Jun 55 87
Then in colums D and E I have more values like in columns B and C.
In column F I have the sum of rows B to E.
I'd like a formula which will calculate the average sum of these rows in the last five days, with the average changing everyday as more rows are added.