Thread: Converting a letter to a numeric value
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Gord Dibben Gord Dibben is offline
external usenet poster
  
Posts: 22,906
Default Converting a letter to a numeric value
=COUNTIF(A1:A100,"x")


Gord Dibben MS Excel MVP


On Thu, 15 Apr 2010 08:33:01 -0700, Jcdc
wrote:

I have a spreadsheet where I need to tally the number of Yes, No and N/A
anwsers. How can I add them if the letter
"x" is being used to mark the answer?

Reply With QuoteReply With Quote