Multiple SUM IFS with same criteria
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 )))
Example:
Answers

It looks like you need to close out each of the SUMIFS functions individually.
=SUMIFS(..........) + SUMIFS(..........) + SUMIFS(..........)
It also looks like each of the SUMIFS have improper syntax.
=SUMIFS(range to sum, 1st criteria range, 1st criteria)

Thanks Paul, I made the adjustment but still get "#unparseable"

Can you copy/paste the new formula to here so I can see exactly what you have?

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

The syntax for each individual SUMIFS is still incorrect.
SUMIFS(range to sum, 1st criteria range, 1st criteria)
SUMIFS([Staff 1 Calculated Hours]@row, [Staff #1]@row, ="Bethany Dodd")

Still getting #unparseable
=SUMIFS([Staff 1 Calculated Hours]@row, [Staff #1]@row, ="Bethany Dodd") +SUMIFS([Staff 2 Calculated Hours]@row, [Staff #2]@row, ="Bethany Dodd") +SUMIFS([Staff 3 Calculated Hours]@row, [Staff #3]@row, ="Bethany Dodd")

Can you post the updated formula if it is still giving a #unparseable something is still incorrect in the formula. Could be the order, a comma, a bracket, a parenthesis, or a typo.

Updated formula is directly above. Thanks Hollie!

I don't see any issues with the formula that is posted. Are you able to provide a screenshot of the formula actually in the sheet similar to the screenshot below (including the column headers)? Color coding may help give us a clue.

It looks like there may be an issue with the column names. Try retyping the formula, but click on the cell being referenced instead of typing out the column name.

If I do that it only references that one cell in that one row  I would like it to search the entire column for every instance of Bethany and then look at the Hours column to Sum the amount for the corresponding row for every time she is referenced (sometimes in Staff #2, sometimes in Staff 3#)

For the record, here is how I finally got it to work. You need to include the full column instead of the row:

It should have worked with the @row references. I didn't mention the entire column because I thought you were trying to get it to sum on each row. But yes. To sum up an entire column you have to reference the entire column. Glad you were able to get it sorted.
Help Article Resources
Categories
 All Categories
 14 Welcome to the Community
 Smartsheet Customer Resources
 62.3K Get Help
 364 Global Discussions
 199 Industry Talk
 427 Announcements
 4.4K Ideas & Feature Requests
 136 Brandfolder
 127 Just for fun
 128 Community Job Board
 444 Show & Tell
 28 Member Spotlight
 1 SmartStories
 283 Events
 35 Webinars
 7.3K Forum Archives
Check out the Formula Handbook template!