Percentage with Multiple Criteria

Hello,

I want to see if there is a more efficient formula to do this.

There are multiple order lines and I want to find out what the percentage of shipped items for that order, but it seems like a slow formula. Any thoughts on how I can make this better?

=IFERROR(COUNTIFS([Sales Order #]:[Sales Order #], [Sales Order #]@row, [Shipped Complete]:[Shipped Complete], @cell = "Yes") / COUNTIF([Sales Order #]:[Sales Order #], [Sales Order #]@row), "")

Find more posts tagged with

Accepted answers

All comments

Paul Newcome

That's pretty much the same way I would do it.

Valeri Nguyen

Thank you @Paul Newcome . I have a sheet that has 6000 lines and using that formula gives me this error message. It's the only formula I have on the sheet.

Paul Newcome

Unfortunately that limitation cannot be expanded to allow for additional references. You will need to find a way to break down the data whether it be by moving some rows to a different sheet or by grouping entries by (for example) Sales Order #, indenting all of the matching sales orders under the parent row, then leveraging hierarchy functions such as CHILDREN.

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.