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?
Answers
-
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
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.8K Get Help
- 434 Global Discussions
- 138 Industry Talk
- 470 Announcements
- 4.9K Ideas & Feature Requests
- 129 Brandfolder
- 148 Just for fun
- 65 Community Job Board
- 486 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 300 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!