Criterion not being recognized when referencing another sheet.

Zcollins1995

Hello!

I am trying to count all of the values in a column that contain the letters "CC:". However, every time I complete my formula it returns with 0 as a result. How can I have it recognize this value?

I have posted a screenshot of the sheet I am referencing. Here is the current formula I am trying to use. Any help is appreciated!

=COUNTIF({2024 Documentation & Projects Range 3}, "CC:")

Range 3 is the column I am referencing in the photo.

Thanks

Zcollins1995

The Task name Column is the Column that is referenced in my Formula.

KPH

Hi @Zcollins1995

The formula

=COUNTIF({2024 Documentation & Projects Range 3}, "CC:")

Is looking for a cell in your Task Name column that EQUALS "CC:"

You need to look for a cell that includes the characters "CC:" along with other things.

Combining a FIND function will do this:

=COUNTIFS({2024 Documentation & Projects Range 3}, FIND("CC:", @cell) > 0)

This will also include cells where "CC:" appears in the middle of the string but it is case sensitive and does include the colon so I don't think this will be an issue for you.