Need help with this formula

Options

Hello,

Can someone recommend a formula to provide an average based on a name on the row. Example, I will have 4 rows for each person but want to average the scores for that person. Image below:

Thank you for your help.

Rebecca


Answers

  • Nick Korna
    Nick Korna ✭✭✭✭✭✭
    Options

    Hi @Rebecca Panaccione ,

    The following formula would show you the average for a candidate in all 4 cells for the avg interview score:

    =AVERAGEIF([Candidate Name]:[Candidate Name], [Candidate Name]@row, [Interview score]:[Interview score])

    Example:

    Is this what you're looking for?

    In terms of reducing the average down to a single line rather than 4 I'd probably use a pivot or export and eliminate duplicates in Excel.

  • That is exactly what I'm looking for. Use the pivot in Excel, correct?

    Rebecca

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!