# Multiple SUM IFS with same criteria

✭✭
edited 01/04/23

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:

• ✭✭✭✭✭✭

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)

• ✭✭

• ✭✭✭✭✭✭

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

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!