Sumifs Adding multiple criteria

Good morning,

I am trying to add up total hours of a {Project Type} Column if the project type contains the following: Implementation, Implementation - Small Market, and ELD Implementation

=SUMIFS([Hours Worked]:[Hours Worked], Date:Date, >=TODAY(-7), Project Type:Project Type, "Implementation", "Implementation - Small Market", "ELD Implementation"

I have tried to double check Parantheses and commas but am getting unparseable message

Best Answers


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!