Thread: how can I get the letters A & S to add 1 in excel
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
Don Guillett[_4_] Don Guillett[_4_] is offline
external usenet poster
  
Posts: 2,337
Default how can I get the letters A & S to add 1 in excel
Of course you can't add letters but maybe
=if(a3="A",1,if(a3="s",2,""))
or use the COUNTIF function. Look in HELP index
--
Don Guillett
SalesAid Software

"johnboy46" wrote in message
...
I have a spread sheet for members in the colum that adds the attendences
up
is there a way of that I can get it to add an A as 1 & an S as 2


Reply With QuoteReply With Quote