Formula If Then

lseal

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!

Paul Newcome

You would use an AVG/COLLECT combo similar to:

=AVG(COLLECT({% Complete}, {Supervisor}, @cell = Supervisor@row))

Paul Newcome

Are you able to provide some screenshots with sample data for context?

lseal

Paul Newcome

You would use an AVG/COLLECT combo similar to:

=AVG(COLLECT({% Complete}, {Supervisor}, @cell = Supervisor@row))

lseal

Thank you so much, that did the trick!

Paul Newcome

Happy to help. 👍️