View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Trevor Little Trevor Little is offline
external usenet poster
 
Posts: 1
Default Summing Cells with Text and Numbers

Is it possible to use the Sumif function to add numbers with a specific
designator in front of it?

Eg.
A row contains strings like: S8, S10, V5, S5

Is there a formula that can total the S's? (Total would be 23)