Formula assistance
Hi,
I know this can be done, but it is over my head. I need a formula that sums and averages based on a cell.
ex: Average the sum of Overall interview scores for each name. Ahlander has 2, Ahmed has 4.
I appreciate assistance.
Rebecca Panaccione
UNM
Best Answer

Hi Rebecca,
I believe this formula should work for you. You would keep adding onto it by repeating the section of the formula using the + symbol while changing the names each time to add another new name.
=IF(Name@row = "Ahlander, Joseph", AVG(COLLECT(Score:Score, Name:Name, "Ahlander, Joseph"))) + IF(Name@row = "Ahmed, Nadia", AVG(COLLECT(Score:Score, Name:Name, "Ahmed, Nadia")))
I hope that helps you out.
Answers

Hi Rebecca,
I believe this formula should work for you. You would keep adding onto it by repeating the section of the formula using the + symbol while changing the names each time to add another new name.
=IF(Name@row = "Ahlander, Joseph", AVG(COLLECT(Score:Score, Name:Name, "Ahlander, Joseph"))) + IF(Name@row = "Ahmed, Nadia", AVG(COLLECT(Score:Score, Name:Name, "Ahmed, Nadia")))
I hope that helps you out.

Thank you Jeff. It is much appreciated!
Rebecca

@Rebecca Panaccione You are welcome. Also, make sure to edit the Score:Score to match your column name "Overall Interview Score".
Help Article Resources
Categories
 All Categories
 14 Welcome to the Community
 Smartsheet Customer Resources
 63.6K Get Help
 403 Global Discussions
 215 Industry Talk
 455 Announcements
 4.7K Ideas & Feature Requests
 141 Brandfolder
 136 Just for fun
 56 Community Job Board
 459 Show & Tell
 31 Member Spotlight
 1 SmartStories
 296 Events
 36 Webinars
 7.3K Forum Archives
Check out the Formula Handbook template!