Add up percentages If statement

I am trying to tally up a total of percentages by Resource name, and and the Level of Effort % that was assigned to their work.

When I do a countif statement it will count the total projects with a Level of Effort, but not total up the weighting %. Is there a way this can be done?

For example, below Chris should be at 147% total.

Find more posts tagged with

Accepted answers

All comments

Ray Lindstrom

@Mike Norman,

I would use the SUMIF formula if you only want to base it on the person. Your "Range" would be "[RM %]. Then your logical expressions would be [Division/Region PM]@cell = "Chris"

I would use the SUMIFS formula if you want multiple criterion.

All the best,
-Ray

Mike Norman

https://community.smartsheet.com/discussion/comment/470668#Comment_470668

Thank you for the response. I changed the range to [RM %] and the @cell for the PM, but am receiving 0 as a result, which is incorrect.

Referencing from my main sheet.

=SUMIFS({RM %}, {Division/Region PM}, "Chris")

Ray Lindstrom

Try this:

Looks like you only have one criteria, so try this with your own columns.

=SUMIF(a:a, @cell = "Chris", b:b)

a:a is the range that you want to search for "Chris"

b:b is the range that you want to sum

Ray Lindstrom

=SUMIF({Division/Region PM}:{Division/Region PM}, @cell = "Chris", {RM %}:{RM %})

Ray Lindstrom

Mike Norman

Now getting unparseable error.

=SUMIF({Division/Region PM}:{Division/Region PM}, @cell = "Chris", {RM %}:{RM %})

Ray Lindstrom

@Mike Norman,

Sorry about that. I was working the formula from the same grid, and replaced the [] with {}.

With cross sheet references, you define the ranges with a singular reference that already references an entire column, so it looks slightly different.

So here's the formula to use from a second grid like you're doing:

=SUMIF({Division/Region PM}, @cell = "Chris", {RM %})

Keep me posted!

BRgds,
-Ray

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.