Getting Weekly Averages Based off of Date and Group

[KoolKatelyn]

Hello,

I'm searching for a formula that will give me the average amount of phone calls that occurred for each phone group within a given week.

I attached my Excel worksheet to help explain what I am looking for.

Any help is appreciated!

[63falcondude]

With "Phone 1" in E2, "Phone 2" in E3, etc. try this in F2:

=AVERAGEIFS(C:C,A:A,">="&DATE(2017,10,9),A:A,"<="&DATE(2017,10,13),B:B,E2)

[KoolKatelyn]

That's exactly what I needed! Thank you!

[63falcondude]

You're welcome.

Thanks for the rep!