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

Counting non-numeric values
 

Thank you very much. Your second suggestion did it. I appreciate your help!
--
JP


"JE McGimpsey" wrote:

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