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.
Help Article Resources
Check out the Formula Handbook template!