Counting range of cells within row

jblunda

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?

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))

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!