Question

I got the following formula to work:

However, now I need to understand how to have this work if its not the same sheet I'm currently referencing.

So my sheet I'm referencing can be called "TEST" for this example.  I need the same formula to work but how do I reference that other sheet?

=COUNTIFS({TEST Range 1}).

Range once populates when I select "Reference another sheet" and then select the column.  Range 1 is actually the column "Status" from my working formula.

Thanks

Paul Newcome · Accepted Answer

From here you would go ahead and continue out the COUNTIFS.

=COUNTIFS({TEST Range 1}, CONTAINS("Active", @cell))