View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Pete_UK Pete_UK is offline
external usenet poster
 
Posts: 8,856
Default Help: Counting characters in Excel

Try this:

=COUNTIF(A:A,"x")

I've assumed you have your x's in column A - adjust to suit.

Hope this helps.

Pete

On Jan 30, 5:36*pm, wrote:
Good morning.

I have a spreadsheet with a column where I'll put an x if a condition
is fullfilled, is there a function so I can count how many x's are in
that column? thanks in advance.