Need help with this formula

Rebecca Panaccione

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

Nick Korna

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.

Rebecca Panaccione

That is exactly what I'm looking for. Use the pivot in Excel, correct?

Rebecca