COUNTIFS across sheets

jomansfi87106

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

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?

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!