SUMIFS with Multiple Criteria

Hi all,

Trying to SUMIFS with multiple criteria and getting an unparseable error.


I need to know the sum of hours by a department for each month.

=SUMIFS({Estimated Hours}:{Estimated Hours}, {Sprint}:{Sprint}, input@row, {Department}:{Department}, "Sales")



Tags:

Best Answer

  • Jeff Reisman
    Jeff Reisman ✭✭✭✭✭✭
    Answer ✓

    @delaneylangston

    Do these reference columns on another sheet?

    {Estimated Hours} {Sprint} {Department}

    If so, you just need to list each column reference by itself, because each one represents a full range:

    =SUMIFS({Estimated Hours}, {Sprint}, input@row, {Department}, "Sales")

    If these are columns on the same sheet, then you need square brackets instead of curly braces, and only necessary on columns with names that are more than one word or that contain a special character or number:

    =SUMIFS([Estimated Hours]:[Estimated Hours], Sprint:Sprint, input@row, Department:Department, "Sales")

    Regards,

    Jeff Reisman, IT Business Analyst & Project Coordinator, Mitsubishi Electric Trane US

    Link: Smartsheet Functions Help Pages Link: Smartsheet Formula Error Messages

    If my answer helped solve your issue, please mark it as accepted so that other users can find it later. Thanks!

Answers

  • Jeff Reisman
    Jeff Reisman ✭✭✭✭✭✭
    Answer ✓

    @delaneylangston

    Do these reference columns on another sheet?

    {Estimated Hours} {Sprint} {Department}

    If so, you just need to list each column reference by itself, because each one represents a full range:

    =SUMIFS({Estimated Hours}, {Sprint}, input@row, {Department}, "Sales")

    If these are columns on the same sheet, then you need square brackets instead of curly braces, and only necessary on columns with names that are more than one word or that contain a special character or number:

    =SUMIFS([Estimated Hours]:[Estimated Hours], Sprint:Sprint, input@row, Department:Department, "Sales")

    Regards,

    Jeff Reisman, IT Business Analyst & Project Coordinator, Mitsubishi Electric Trane US

    Link: Smartsheet Functions Help Pages Link: Smartsheet Formula Error Messages

    If my answer helped solve your issue, please mark it as accepted so that other users can find it later. Thanks!

  • Austin Smith
    Austin Smith ✭✭✭✭✭

    Are you pulling hour data from another sheet?

    What is input@row? Can you expand the view of the sheet or reference area?

    too many unknown data sources and formats to give a good answer

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!