View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
ryanb.[_2_] ryanb.[_2_] is offline
external usenet poster
 
Posts: 3
Default Counting non-numeric values

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?
_________________
one way:

assuming X's in row 1

=COUNTIF(1:1,"X")

HTH