View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
RagDyeR RagDyeR is offline
external usenet poster
 
Posts: 3,572
Default Counting non-numeric values

You did say ROW, right?

For an *entire* row, say Row5:

=Countif(5:5,"x")

For a range of cells within Row5:

=Countif(C5:Y5,"x")

--

HTH,

RD
================================================== ===
Please keep all correspondence within the Group, so all may benefit!
================================================== ===

"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