Including Contact Criteria in SUMIFS Formula


I am attempting to include a Contact Name as criteria in a SUMIFS formula.

I'd like to sum Claire Robertson-Kraft's "September Actual Hours" for the "Red & Blue Exchange" project.

I've written this formula (below) and it is returning the #CONTACT EXPECTED error. Does anyone have any advice on how to fix it?

=SUMIFS([September Actual Hours]:[September Actual Hours], Project:Project, ="Red & Blue Exchange", Who:Who, ="Claire Robertson-Kraft")

Thank you!

Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!