Alternative to COUNTIF with HAS Formula

I need help, please :)

On a support sheet, I have a list of Zip codes and the areas of the city they correspond to. On my main sheet, I have a "Company HQ Address" column, that contains the Zip code, but NOT on its own column, it's listed within the cell containing the full address. When I use "=COUNTIF({Source Sheet Range 2}, HAS(@cell, "89148")) for example; it only counts it if the cell on the address column lists the Zip code without additional data, which won't work for me.

Ultimately, I want to count the number of rows/records I have per area of the City (North West, North Central, North East, South West, South East). Any ideas on how to fix my formula above, or any other/better way to do this that I am unaware of?

Thank you so much in advance!

Find more posts tagged with

Formulas

Accepted answers

Mike TV

@Barbara Silva

Hi Barbara. HAS requires an exact match. Switch to using CONTAINS instead.

=COUNTIF({Source Sheet Range 2}, CONTAINS("89148", @cell))

CONTAINS is formatted a little differently so you'll need to put what to search for before where to search at.

All comments

Mike TV

@Barbara Silva

Hi Barbara. HAS requires an exact match. Switch to using CONTAINS instead.

=COUNTIF({Source Sheet Range 2}, CONTAINS("89148", @cell))

CONTAINS is formatted a little differently so you'll need to put what to search for before where to search at.

Barbara Silva

It worked! Thank you SO much!!

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.