Average with criteria

I need some help regarding making an average.

There is multiple rows with the text "Mekanisk" in it at "System" column, and a corresponding "%" at the "Fullført" colum.

How do I make an average of all these uniqe % values?

Thank's! :)

Find more posts tagged with

Accepted answers

Nick Korna

Hi @TorAtle Myrmel,

If you're after an average for all the %ages in "Fullført" against rows containing "Mekanisk" in "System" then you would use the following formula:

=AVERAGEIF([System]:[System], CONTAINS("Mekanisk", @cell), [Fullført]:[Fullført])

Example:

Hope this helps, but if you've any questions or comments then just post! 😊

All comments

Nick Korna

Hi @TorAtle Myrmel,

If you're after an average for all the %ages in "Fullført" against rows containing "Mekanisk" in "System" then you would use the following formula:

=AVERAGEIF([System]:[System], CONTAINS("Mekanisk", @cell), [Fullført]:[Fullført])

Example:

Hope this helps, but if you've any questions or comments then just post! 😊

TorAtle Myrmel

Thank you!

Nick Korna

No problem, happy to have helped!

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.