Finding Average - Multiple Values in Single Cell



I am trying to find a formula where I can find the average test score of multiple scores entered into a single cell- see screenshot below. I need the average to autopopulate based off of the numbers entered into a single entry in Average Score.

Thank you for the help,


  • Amber Eakin
    Amber Eakin ✭✭✭✭✭✭

    Hi @lex.robert - Will it always be a total of five, 2-digit scores that you need to average? If so, this should work:

    =AVG(VALUE(LEFT([Average Score]@row, 2)), VALUE(MID([Average Score]@row, 5, 2)), VALUE(MID([Average Score]@row, 9, 2)), VALUE(MID([Average Score]@row, 13, 2)), VALUE(MID([Average Score]@row, 17, 2)))

    Let me know if that helps!

    Amber Eakin, MSLS, M.Ed.

    Adult Education Specialist | Process Improvement Enthusiast

  • Paul Newcome
    Paul Newcome ✭✭✭✭✭✭

    If they are not always going to be 5 selections of two digits each, can you provide a list of the different variables such as number of selections made or possible digits in each selection?

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!