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
- Smartsheet Customer Resources
- 62.8K Get Help
- 376 Global Discussions
- 207 Industry Talk
- 440 Announcements
- 4.5K Ideas & Feature Requests
- 139 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 449 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 284 Events
- 33 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!