AVG(COUNTIF) question

Will.Dennis

I am not a programmer and am trying to build a dashboard, but I need to figure out how to do a an AVG calculation.

Can someone help me with the formula?

I need to calculate the Average % Complete grouped by primary Assignment.

For Instance:

=AVG(% Complete) where Primary Assignment = "Business"

=AVG(% Complete) Where Primary Assignment - "Technology"

Any assistance would be greatly appreciated.

Find more posts tagged with

Accepted answers

All comments

Antonio Figueroa

Try using an AVERAGEIF() formula

=AVERAGEIF([Primary Assignment]:[Primary Assignment],"Business",[% Complete]:[% Complete])

then you would have to make the same formula for "Technology"

Will.Dennis

When I put in that calculation it is saying #unparseable.

=AVERAGEIF([Primary Assignment]:[Primary Assignment],"Business", [% Complete]:[% Complete])

Siva Bala

Is it possible to have multiple criteria instead of just one?

Paul Newcome

Are you able to provide a screenshot of the formula that is throwing the error directly in the sheet similar to the screenshot below?

Will.Dennis

Here you go.

Paul Newcome

@Will.Dennis The formula in your most recent screenshot has a few issues with it. Aside from the syntax issues, it also looks like you are referencing two different sheets?

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, latest, sort, sortType, lookupSort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.