Counting open tickets based on company name and ticket status

Nick Winkley

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!

Paul Newcome

Try this instead...

=COUNTIFS({Maintenance tracking Sheet Range 2}, [Company Name]@row, {Maintenance tracking Sheet Range 3}, "Open")

Paul Newcome

Try this instead...

=COUNTIFS({Maintenance tracking Sheet Range 2}, [Company Name]@row, {Maintenance tracking Sheet Range 3}, "Open")