Average distance travelled in a particular date range by each team

Ahmet - newby

Hi Community,

Can you help me with a formula to find the average distance that Team "Blues" travelled in July?

Many thanks,

Ahmet

Bassam Khalil

Hi @Ahmet - newby

Hope you are fine, please try the following formula:

=IFERROR(AVG(COLLECT(Distance:Distance, Team:Team, @cell = "Blue", Date:Date,
MONTH(@cell) = 7)), "")

The following screenshot shows the result:

Ahmet - newby

That's fantastic Bassam - thank you so much 👍️

Bassam Khalil

@Ahmet - newby

You are welcome and I will be happy to help you any time

Bassam Khalil

Hi @Ahmet - newby

Hope you are fine, please try the following formula:

=IFERROR(AVG(COLLECT(Distance:Distance, Team:Team, @cell = "Blue", Date:Date,
MONTH(@cell) = 7)), "")

The following screenshot shows the result:

Ahmet - newby

That's fantastic Bassam - thank you so much 👍️

Bassam Khalil

@Ahmet - newby

You are welcome and I will be happy to help you any time