Percent Complete from an External Reference

Hello!

I'm working on a project plan for work and have external references to another sheet. I'd like to accomplish a count or countif function to help me with the below:

If "Column X" = "Y" then count the sum of "Y" in that column and divide it by the total rows for a percentage complete.

Meaning, I want to count the amount of "Y"s listed in a column and turn it into a percentage based on the total sum of the items in the column.

I'm sure this was terribly explained so I apologize in advance and appreciate any and all help!

Find more posts tagged with

Accepted answers

All comments

David Tutwiler

Are you looking for something like this?

=IF([Column X]@row = "Y", AVG([Column Y]))

Allison Heller

I received a "#DIVIDE BY ZERO" result when doing the below as suggested:

=IF({NAPA Mock Range 1} = "Y", AVG({NAPA Mock Range 2}))

David Tutwiler

I'm assuming Range 1 is looking at a single cell and Range 2 is looking at the entire column? Is that correct?

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.