Urgent: Please help with averaging formula

Rebecca Panaccione

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

Paul Newcome

You would use (adjust column names as needed):

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

Paul Newcome

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

https://help.smartsheet.com/function/averageif

Rebecca Panaccione

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=

Paul Newcome

You would use (adjust column names as needed):

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

Rebecca Panaccione

That worked! Beautiful. Thank you!

Paul Newcome

Happy to help. 👍️