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

Emily Tiffany-Davis

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.

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