Urgent: Please help with averaging formula



Is there a formula to average a number based on data in a column?

In this sheet, I want to formulate and average the Interview Score based on the name of the applicant. Example: Wilfred, Furtado has 3 scores. In the AVG Int Score column, I want to average the total scores by the numbers of interview scores on the sheet.

Can you help?

Rebecca Panaccione

Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!