Calculating Averages with Different Columns

Cayla Davis

Hi - I am trying to calculate average based on different columns, example…

Sandra A - TTL Seconds + Kelly B - TTL Seconds + Meri - TTL Seconds + Coen - TTL Seconds = Average of those numbers for each row

Does anyone know the formula to do that?

Paul Newcome

You would use the standard AVG function.

=AVG([Column1]@row, [Column 2]@row, [Column 3]@row, …………………)

Paul Newcome

You would use the standard AVG function.

=AVG([Column1]@row, [Column 2]@row, [Column 3]@row, …………………)

Cayla Davis

Thank you so much!!!!!

Paul Newcome

Happy to help. 👍️