COUNTIF & CONTAINS Function

Options
Rabia
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!

Answers

  • Ray Lindstrom
    Ray Lindstrom ✭✭✭✭✭✭
    edited 11/30/22
    Options

    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