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!