Count Cells that begin with a specific text

I wanted to COUNTIF the number of cells that start with specific four letters in a column of a reference sheet. I used the formula below and it returns zero.

=COUNTIF({Reference Sheet}, "ABCD")

Is there a formula to return the number of cells that have the first four letters as "ABCD"?

Find more posts tagged with

Sheets

Formulas

Dashboards

functionality

Accepted answers

Paul Newcome

Try something like this...

=COUNTIFS({Reference Sheet}, LEFT(@cell, 4) = "ABCD")

All comments

Paul Newcome

Try something like this...

=COUNTIFS({Reference Sheet}, LEFT(@cell, 4) = "ABCD")

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.