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

Find more posts tagged with

Formulas

Accepted answers

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

All comments

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

=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

Sign in to join the conversation!

Quick Links

Component react.discussion.discussions had an error.

ref must be one of: categoryID, siteSectionID, category, category/categoryID, category/name, category/description, category/url, category/allowedDiscussionTypes, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, sort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.