Calculating Averages with Different Columns

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?

Find more posts tagged with

Formulas

Accepted answers

Paul Newcome

You would use the standard AVG function.

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

All comments

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. 👍️

Sign in to join the conversation!

Quick Links

Component react.discussion.discussions had an error.

ref must be one of: categoryID, siteSectionID, category, category/categoryID, category/name, category/description, category/url, category/allowedDiscussionTypes, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, sort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.