counting the number of times value of "x" appears in a row

[Hugh]

I need to count the number of times the value of "x" appears in a row.
Cannot figure out how to do it.

 

[VBA Noob]

=COUNTIF(1:1,"X")

or

=SUMPRODUCT(--(1:1="x"))

VBA Noob

 

[Hugh]

Thank you very much!