AVGW Formula for Multiple Cells in One Column

I am trying to apply weights to multiple cells in a "% Completed" column.

My current formula just averages out the values for the selected cells:

=AVG([% Complete]3, [% Complete]5, [% Complete]7, [% Complete]9, [% Complete]11, [% Complete]53)

I'd like to apply weights of 10% to row 3, 5, 7, 9, and 53 with a weight of 50% to row 11. I can't find a way to do this with the AVGW formula that allows me to select only these 6 cells. I tried to use the collect function but kept getting an unparseable error.

Find more posts tagged with

Formulas

Accepted answers

VBAGuru

You could try something like:

=Sum([% Complete]3, [% Complete]5, [% Complete]7, [% Complete]9, [% Complete]11*5, [% Complete]53)/10

All comments

VBAGuru

You could try something like:

=Sum([% Complete]3, [% Complete]5, [% Complete]7, [% Complete]9, [% Complete]11*5, [% Complete]53)/10

bcg5140

Thanks so much! That worked, simpler than I thought

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.