View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
BryanP Man
 
Posts: n/a
Default Does Excel support Alphanumberic formulas?

In my work, Patients earn "Points" for specific goals and I enter the total
in an excel spreadsheet, however, some days are "F"ree and some are "P"ass
days and only the letter is used. Is there a formula in excel I can use to
combine alpha and numberic data and still get sum, and avg results?