Need help with this formula
Hello,
Can someone recommend a formula to provide an average based on a name on the row. Example, I will have 4 rows for each person but want to average the scores for that person. Image below:
Thank you for your help.
Rebecca
Answers

Hi @Rebecca Panaccione ,
The following formula would show you the average for a candidate in all 4 cells for the avg interview score:
=AVERAGEIF([Candidate Name]:[Candidate Name], [Candidate Name]@row, [Interview score]:[Interview score])
Example:
Is this what you're looking for?
In terms of reducing the average down to a single line rather than 4 I'd probably use a pivot or export and eliminate duplicates in Excel.

That is exactly what I'm looking for. Use the pivot in Excel, correct?
Rebecca
Help Article Resources
Categories
Check out the Formula Handbook template!