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.
Answers
-
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 -
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")
-
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
-
=SUMIF({Division/Region PM}:{Division/Region PM}, @cell = "Chris", {RM %}:{RM %})
-
-
Now getting unparseable error.
=SUMIF({Division/Region PM}:{Division/Region PM}, @cell = "Chris", {RM %}:{RM %})
-
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
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 66K Get Help
- 429 Global Discussions
- 149 Industry Talk
- 488 Announcements
- 5.2K Ideas & Feature Requests
- 85 Brandfolder
- 152 Just for fun
- 74 Community Job Board
- 499 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 305 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!