# Formula assistance

Options

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

• ✭✭✭
Options

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.

• ✭✭✭
Options

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.

• Options

Thank you Jeff. It is much appreciated!

Rebecca

• ✭✭✭
Options

@Rebecca Panaccione You are welcome. Also, make sure to edit the Score:Score to match your column name "Overall Interview Score".

## Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!