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

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!