Urgent: Please help with averaging formula

Hi,

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

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!