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

Find more posts tagged with

Formulas

Accepted answers

All comments

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.

Sign in to join the conversation!

Quick Links

Component react.discussion.discussions had an error.

ref must be one of: categoryID, siteSectionID, category, category/categoryID, category/name, category/description, category/url, category/allowedDiscussionTypes, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, sort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.