Formula for taking an average of duplicate rows

edited 12/09/19 in Formulas and Functions

I'm attempting to construct a formula for taking averages of multiple ratings from several raters across three vendors.

Sheet 1 looks like:

Rater - Category - Vendor A Rating - Vendor B Rating - Vendor C Rating


Sheet 2 looks like:

Category - Vendor A Rating Avg - Vendor B Rating Avg - Vendor C Rating Avg


On sheet two, I need to get the average rating for each category and vendor. The formula should look at sheet one and determine where the category matches and then average the values in that row. I believe in Excel there is a AVGIF function to do this.


Any help is appreciated.


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!