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
|