Multiple SUM IFS with same criteria

Anne77 ✭✭
edited 01/04/23 in Formulas and Functions

I'm trying to add up staff hours when the staff assigned could fall into any of 3 categories. How can I sum them all together?

This is how I've started but getting "#unparseable"

=SUMIFS([Staff #1]@row = "Bethany XXX", [Staff 1 Calculated Hours]@row +SUMIFS([Staff #2]@row = "Bethany XXX", [Staff 2 Calculated Hours]@row +SUMIFS([Staff #3]@row = "Bethany XXX", [Staff 3 Calculated Hours]@row )))



Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!