SUMIFS for multiple criteria in same range

Jackson Pavelka

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?

PWNA 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]).