Counting range of cells within row

I'm trying to count the amount of times a cell within a row has a specific word:

=COUNTIF([Labelling)@row,[Training]@row), "Fail")

If Fail shows in any cell I want the function to result a readout of 1. If two cells have Fail, then the result would be 2, etc.

Instead of my expected result, I get #UNPARSEABLE in the cell. What am I missing?

Find more posts tagged with

Formulas

Accepted answers

Samuel Mueller

@jblunda are your column names spelled right?

also sorry there is an extra parenthesis I did not see in your formula try this

=COUNTIF([Labelling]@row:[Training]@row, contains("Fail",@cell))

All comments

Samuel Mueller

@jblunda your syntax is wrong, you have a comma where you need a colon.

=COUNTIF([Labelling)@row:[Training]@row), "Fail")

that would count if your cells only has the word Fail in it. If you have multiple text including fail you need this

=COUNTIF([Labelling)@row:[Training]@row), contains("Fail",@cell))

jblunda

I see what you mean, but neither of these works. I still get the same #UNPARSEABLE error.

Samuel Mueller

@jblunda are your column names spelled right?

also sorry there is an extra parenthesis I did not see in your formula try this

=COUNTIF([Labelling]@row:[Training]@row, contains("Fail",@cell))

jblunda

That was the trick....thank 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.