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?
Best Answer

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

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

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

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

That was the trick....thank you!
Help Article Resources
Categories
Check out the Formula Handbook template!