Formula If Then
Sheet A: Primary sheet that lists employee data (name, ID #, supervisor, training a, training b...training g, avg training completion)
Sheet B: I want to write a formula that shows per supervisor, the average training completion of all of their staff. How do I write this formula to pull from sheet A and then average numbers in the last column but only if the supervisor in an earlier column matches?
For reference, my end goal is to make a dashboard with this information for supervisors to see, but I think I need data consolidated from Sheet A on to Sheet B to use for the dashboard.
Thanks!
Best Answer
-
You would use an AVG/COLLECT combo similar to:
=AVG(COLLECT({% Complete}, {Supervisor}, @cell = Supervisor@row))
Answers
-
Are you able to provide some screenshots with sample data for context?
-
You would use an AVG/COLLECT combo similar to:
=AVG(COLLECT({% Complete}, {Supervisor}, @cell = Supervisor@row))
-
Thank you so much, that did the trick!
-
Help Article Resources
Categories
Check out the Formula Handbook template!