Count how many times a word appears in a range of cells

I am trying to use a cross sheet formula to count how many times specific words in a range of cells. I keep getting a 0 and not sure why. Any direction will be greatly appreciated. Below is the formula I used.

=COUNTIF({Touch Log - Detail Range 2}, FIND("Call", Submitter@row) > 0)

I hope that the screenshots help.

Find more posts tagged with

Formulas

Accepted answers

All comments

Darin Wagner

Billy,

I'll take a shot and see if it works for you:

This would look for "Call" in the specific row and give you a value.

=COUNTIFS([Touch Type]@row, FIND("Call", @cell) > 0)

If you wanted to do it for the range, it would be something like:

=COUNTIFS([Touch Type]1:[Touch Type]3, FIND("Call", @cell) > 0)

Also the "Call" after FIND is case sensitive.

Hope that helps!

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.