COUNTIFS across sheets

Hi,

I am trying to pull data from two sheets into one, where it will be used to support reports. Is this syntax correct for this? I'm getting the incorrect argument set error.

=COUNTIFS({JDP Attribute}, "Safety & Reliability; 1.1 Reliability of gas service", {2022 CSAT Comms Range 2}, "Safety & Reliability; 1.1 Reliability of gas service")

Thanks,

John

Find more posts tagged with

Formulas

Accepted answers

Darren Mullen

@jomansfi87106 If you are trying to use off sheet references from more than one sheet in the same function, this will not work. However, you can use 2 functions to accomplish the same thing. Such as:

=COUNTIF({JDP Attribute}, "Safety & Reliability; 1.1 Reliability of gas service") + COUNTIF({2022 CSAT Comms Range 2}, "Safety & Reliability; 1.1 Reliability of gas service")

Does that work for you?

All comments

Darren Mullen

@jomansfi87106 If you are trying to use off sheet references from more than one sheet in the same function, this will not work. However, you can use 2 functions to accomplish the same thing. Such as:

=COUNTIF({JDP Attribute}, "Safety & Reliability; 1.1 Reliability of gas service") + COUNTIF({2022 CSAT Comms Range 2}, "Safety & Reliability; 1.1 Reliability of gas service")

Does that work for you?

jomansfi87106

This worked, thank you so much!

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.