Conditional Weighted Average

Laura Krylov ASGLLC

Hello Experts!

I see AVGW but I need an average formula to use with an If. Is there such a formula?

I have this formula that works great for an average but is not a weighted average.

'=AVERAGEIF([Task Name]:[Task Name], "«SPECIFIC TEXT I SEARCH FOR»", [% Complete]:[% Complete])

Anyone have a solution?

Find more posts tagged with

Accepted answers

All comments

Paul Newcome

You could use a COLLECT function.

=AVGW(COLLECT(range to average, filter range, criteria), COLLECT(range to use for weight, filter range, criteria))

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.