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
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.7K Get Help
- 433 Global Discussions
- 136 Industry Talk
- 468 Announcements
- 4.9K Ideas & Feature Requests
- 143 Brandfolder
- 147 Just for fun
- 64 Community Job Board
- 466 Show & Tell
- 32 Member Spotlight
- 2 SmartStories
- 298 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!