modestcode
New Member
- Joined
- Dec 30, 2022
- Messages
- 2
- Office Version
- 2016
- 2013
- 2011
- 2010
- 2007
- Platform
- Windows
Hi, I am feeling a bit stumped on this excel formula I'm working on. The answer is probably easy.. If i can figure out a way to address this in a simplified example, then I can probably apply it to my more complex dataset. Essentially I'm trying to create a formula that only counts users with tickets in closed status. So in the example below, I would expect Frank to be the only user tied to Closed tickets, and my formula result to be 1. There are duplicate ticket IDs in my dataset but other fields make them unique records. The answer is probably easy, but any help would be greatly appreciated. Thanks!
Example of data:
Example of data:
User | Ticket ID | Status |
Bob | 1 | Closed |
Bob | 1 | Closed |
Bob | 2 | Open |
Bob | 3 | Closed |
Frank | 4 | Closed |
Frank | 5 | Closed |
Frank | 6 | Closed |
Steve | 7 | Open |
Steve | 7 | Open |