#### newbie_excel

##### New Member

- Joined
- Feb 17, 2007

- Messages
- 23

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.