Average distance travelled in a particular date range by each team
Hi Community,
Can you help me with a formula to find the average distance that Team "Blues" travelled in July?
Many thanks,
Ahmet
Best Answers
-
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:
bassam.khalil2009@gmail.com
โ๏ธ Are you satisfied with my answer to your question? Please help the Community by marking it as an ( Accepted Answer), and I will be grateful for your "Vote Up" or "Insightful"
-
That's fantastic Bassam - thank you so much ๐๏ธ
-
You are welcome and I will be happy to help you any time
bassam.khalil2009@gmail.com
โ๏ธ Are you satisfied with my answer to your question? Please help the Community by marking it as an ( Accepted Answer), and I will be grateful for your "Vote Up" or "Insightful"
Answers
-
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:
bassam.khalil2009@gmail.com
โ๏ธ Are you satisfied with my answer to your question? Please help the Community by marking it as an ( Accepted Answer), and I will be grateful for your "Vote Up" or "Insightful"
-
That's fantastic Bassam - thank you so much ๐๏ธ
-
You are welcome and I will be happy to help you any time
bassam.khalil2009@gmail.com
โ๏ธ Are you satisfied with my answer to your question? Please help the Community by marking it as an ( Accepted Answer), and I will be grateful for your "Vote Up" or "Insightful"
