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!

Find more posts tagged with

Formulas

functionality

Cell linking

Accepted answers

Paul Newcome

Try this instead...

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

All comments

Paul Newcome

Try this instead...

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

Sign in to join the conversation!

Quick Links

Component react.discussion.discussions had an error.

ref must be one of: categoryID, siteSectionID, category, category/categoryID, category/name, category/description, category/url, category/allowedDiscussionTypes, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, sort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.