View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
worker worker is offline
external usenet poster
 
Posts: 2
Default How can I add numbers such as 1.5R + 2.5R?

I am trying to add numbers that have alpha characters at the end. I have
tried nesting the SUM and IF functions using FREQUENCY for unique values but,
have been unsuccessful. Any suggestions please.