Formula for Average
Hola comunidad, alguno de ustedes a podido o pueda ayudarme en crear una formula para calcular el promedio en dias en que una persona completa sus actividades??????:I
**Translated via Google Translate**
Hello community, any of you have been able or can help me to create a formula to calculate the average number of days in which a person completes their activities ??????: I
Answers
-
You would need to have a separate column on the source sheet that calculates the total number of days on each row.
From there you would use an AVG/COLLECT combo to average the helper column based on the name.
-
hola @Paul Newcome
Intente agregar lo siguiente pero no entiendo que me sigue fallando :(
=AVG({Copia de Operaciones Rango 1}, {Copia de Operaciones Rango 4}), COLLECT({Copia de Operaciones Rango 3}]:"Brisedy "; ([{Copia de Operaciones Rango 3}]:"Briseidy"))
-
Hi @Brii
Can you identify what each of your references represents? A screen capture would be helpful, but please block out sensitive data.
I agree with Paul's solution, to have a Helper Column in the source sheet which has the number of days per-row. Then your formula would look something like this:
=AVG(COLLECT({Range 1 - Total Days}, {Range with Names}, "Brisedy"))
Cheers,
Genevieve
Need more help? 👀 | Help and Learning Center
こんにちは (Konnichiwa), Hallo, Hola, Bonjour, Olá, Ciao! 👋 | Global Discussions
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.8K Get Help
- 434 Global Discussions
- 138 Industry Talk
- 470 Announcements
- 4.9K Ideas & Feature Requests
- 129 Brandfolder
- 148 Just for fun
- 65 Community Job Board
- 486 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 300 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!