Options

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

• ✭✭✭✭✭✭
Options

You would use (adjust column names as needed):

=AVERAGEIF(Name:Name, Name@row, Score:Score)

• ✭✭✭✭✭✭
Options

Try the AVERAGEIF function. It has the same syntax as a SUMIF but averages instead of sums.

• Options

I have this so far then,

What is the "equal to"? Do I have to do this on each row for each name. I need it to be smart. :(

=AVERAGEIF([Interview Score]:[Interview Score], [Applicant Name]@row=

• ✭✭✭✭✭✭
Options

You would use (adjust column names as needed):

=AVERAGEIF(Name:Name, Name@row, Score:Score)

• Options

That worked! Beautiful. Thank you!

• ✭✭✭✭✭✭
Options

Happy to help. 👍️

## Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!