Counting non-numeric values
One way:
=COUNTA(2:2)
or, if you *only* want to count x's:
=COUNTIF(2:2,"x")
In article ,
paljowestsub wrote:
I have a spreadsheet with the letter x in various cells. I want to count the
number of x's in a particular row of cells. What formula do I use and how do
I structure the formula?
Thank you!
Joe Palczynski
|