SUMIFS with Multiple Criteria

delaneylangston

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")

Jeff Reisman

@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")

Jeff Reisman

@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")

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