Formula assistance

Rebecca Panaccione

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

Jeff M.

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.

Jeff M.

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.

Rebecca Panaccione

Thank you Jeff. It is much appreciated!

Rebecca

Jeff M.

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