Average calculation from overall ratings

Joseph Aloysias
Joseph Aloysias ✭✭✭✭✭

Hi All, I'm trying to calculate average of these rating in Average column excluding "NA",

for example if "NA" is applied in any column the formula should exclude that column and calculate for the remaining columns.

Please help me with the formula.


Tags:

Best Answer

  • Nick Korna
    Nick Korna ✭✭✭✭✭✭
    Answer ✓

    Hi @Domnic Victor ,

    This formula should do it for you:

    =AVG([Domain Knowledge]@row:[Overall rating of the engagement]@row)

    The NAs will already be excluded in the average:

    One caveat: from your screenshot it looks like there are possibly some hidden columns between "Timely Delivery" and "Alignment..." so I would suggest moving these to one side or the other of the columns you're trying to average so they are not included.

    Hope this helps - any questions etc. then just post! 😊

Answers

  • Nick Korna
    Nick Korna ✭✭✭✭✭✭
    Answer ✓

    Hi @Domnic Victor ,

    This formula should do it for you:

    =AVG([Domain Knowledge]@row:[Overall rating of the engagement]@row)

    The NAs will already be excluded in the average:

    One caveat: from your screenshot it looks like there are possibly some hidden columns between "Timely Delivery" and "Alignment..." so I would suggest moving these to one side or the other of the columns you're trying to average so they are not included.

    Hope this helps - any questions etc. then just post! 😊

  • Joseph Aloysias
    Joseph Aloysias ✭✭✭✭✭

    its working! Thank you so much, you made it very simple.

  • Nick Korna
    Nick Korna ✭✭✭✭✭✭

    No problem, glad to be of assistance!

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!