SUMIFS for multiple criteria in same range

Hello,

I am trying to generate a sum based on Department Name and Ticket Count. However, so of my formulas need to sum multiple Department Names and their respective ticket counts. The issue is I have multiple names for the same department pulling from the system we are counting the tickets from. Essentially I have two department names that I need the sum of the ticket counts from both departments.

Currently I have tried: =SUMIFS({Tickets}, {Department Name}, @cell = "Department Name 2", {Dept Region}, @cell = "Department Name 3")

My understanding is that this should return the sum of the ticket counts for Department Name 2 and Department Name 3. It is just returning a zero. Can someone tell me what I am doing wrong here?

Screen Shot 2022-09-29 at 2.31.11 PM.png

Find more posts tagged with

Accepted answers

All comments

Sam_Harwart

Hi @Jackson Pavelka ,

SUMIFS uses multiple filters for a single sum and requires the row to meet all of the criteria. In your example, I think what you'll want to do is a SUMIF + a different SUMIF.

Something like =SUMIF([Department Name]:[Department Name], "Department Name 1", [Tickets]:[Tickets]) + SUMIF([Department Name]:[Department Name], "Department Name 2", [Tickets]:[Tickets]).

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.