View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Arnold R Arnold R is offline
external usenet poster
 
Posts: 5
Default Counting function

I have a column of data that contains either the letter n or the letter y.
How can I count the number of cells that contain the letter n? I would have
thought this would be done with the COUNTA function but I can't see how.
Thanks for any help.