Counting open tickets based on company name and ticket status
Hi,
I'm trying to count the number of open tickets by company name, and the cells I'm referencing are in another sheet. Here's my formula so far:
=IF({Maintenance tracking Sheet Range 2} = [Company Name]@row, COUNTIF({Maintenance tracking Sheet Range 3}, {Maintenance tracking Sheet Range 3} = "Open"))
But I'm getting an INVALID OPERATION error. The Range 2 is checking to see if the company name matches to the company name on our ticketing sheet, and Range 3 is a ticket status column, formatted as a dropdown. Any help would be greatly appreciated!
Best Answer
-
Try this instead...
=COUNTIFS({Maintenance tracking Sheet Range 2}, [Company Name]@row, {Maintenance tracking Sheet Range 3}, "Open")
Answers
-
Try this instead...
=COUNTIFS({Maintenance tracking Sheet Range 2}, [Company Name]@row, {Maintenance tracking Sheet Range 3}, "Open")
Help Article Resources
Categories
Check out the Formula Handbook template!