SUMIFS for multiple criteria in same range

Options
Jackson Pavelka
Jackson Pavelka ✭✭✭
edited 09/29/22 in Formulas and Functions

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?


Answers

  • PWNA Sam Harwart
    PWNA Sam Harwart ✭✭✭✭✭
    Options

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

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!