COUNTIF & CONTAINS Function

Rabia

Hi,

If I have the following list in yellow shown below in one sheet

And I want to cross reference with the yes row shown below in another sheet

To get a final count, of the Job Order Numbers that are Yes, how can I do that? I feel like I need a CountIf and contains function but I can’t seem to get it to work. Any suggestions would be appreciated!

Ray Lindstrom

Hi @Rabia,

Try this:

=IF(CONTAINS("Yes", {Response}:{Response}), COUNTM({Unique Job Numbers}:{Unique Job Numbers}), "")

This assumes {Response} is your cross-sheet reference name for the Response column, and {Unique Job Numbers} is your cross-sheet reference name for your Unique Job Numbers column. If these are not the names, then update this statement to use your own names.

This will return the number of Unique Job Numbers listed in the Yes row(s).

Hope this helps!

BRgds,

-Ray