How do I count occurrences of a word in a row?

I'd love to count the number of times the word "below" occurs in a row.

Apologies for the simplicity of this question, I'm very new to Smart Sheets!

This word could occur as either "below target" or "significantly below target", but I'm hoping just to count ALL instances of "below" once if that's possible.

I've tried =COUNTIF(@ROW, below)

=COUNTIF(@ROW, "below")

=COUNTIF(@ROW, {below})

and all are unparseable, so I'm misunderstanding something very basic here.

Find more posts tagged with

Formulas

Accepted answers

All comments

Leibel S

See below formula.

Replace the column names (bolded text) with your specific columns you wish to count.

=COUNTIF([column1]@row:[column9]@row, CONTAINS("below", @cell))

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.