Hi I have a little question,

I work in a call center where the system calculate the average numbers of calls per hour that an agent takes.

We already have the daily average but we do not have the average of the week before the end of the week. I would like to calculate this on a daily basis instead.

What I have is the agent ID + the average of the number of calls he's taken per hour.

I will be pasting the information in a sheet on a daily basis...

On another sheet I have the Agent ID and on the next column I would like to calculate the Average of the week.

With which formula can I do this ?