Thread: Sum and subtract columns when one cell contains preceding text
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
K Tuck K Tuck is offline
external usenet poster
  
Posts: 1
Default Sum and subtract columns when one cell contains preceding text
I need to add columns: A1=JA1098027 and B1=6, then subtract C1=1. All of
column A contains 1-3 letters preceding the number so nothing I've tried
works. Columns B and C are numeric only. Anyone know the secret formula for
this one? Thanks.
Reply With QuoteReply With Quote