Average formula question
I have a sheet that I need the average formula broken down by person. There are three different people scoring the applicant and I need to average the applicant scores. The formula I have entered is scoring the entire column.
Answers
-
Can you provide a screenshot with sensitive/confidential data removed, blocked, or replaced with "dummy data" as needed?
You should be able to accomplish this with an AVERAGEIF function, but n case that doesn't work, more details may be needed to help find a solution.
-
Thank you, I will give that a try.
-
Happy to help. 👍️
Feel free to revisit the thread with you results.
Help Article Resources
Categories
Want to practice working with formulas directly in Smartsheet?
Check out the Formula Handbook template!
Check out the Formula Handbook template!