Counting non-numeric values
 

Try this:

=COUNTIF(A1:J1,"x")

Adjust the range to suit.

--
Biff
Microsoft Excel MVP


"paljowestsub" wrote in message
...
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 for your help, especially on New Year's Day! That did it.
--
JP


"T. Valko" wrote:

Try this:

=COUNTIF(A1:J1,"x")

Adjust the range to suit.

--
Biff
Microsoft Excel MVP


"paljowestsub" wrote in message
...
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
 

You're welcome. Thanks for the feedback!

Have a great and prosperous New Year!

--
Biff
Microsoft Excel MVP


"paljowestsub" wrote in message
...
Thank you for your help, especially on New Year's Day! That did it.
--
JP


"T. Valko" wrote:

Try this:

=COUNTIF(A1:J1,"x")

Adjust the range to suit.

--
Biff
Microsoft Excel MVP


"paljowestsub" wrote in message
...
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