Thread: Summing Cells with Text and Numbers
View Single Post
  #3  
Old January 12th, 2010, 08:13 PM posted to microsoft.public.excel.worksheet.functions
Bernard Liengme
external usenet poster
  
Posts: 516
Default Summing Cells with Text and Numbers
=SUMPRODUCT((LEFT(A11)="S")*(MID(A11,2,20)))
best wishes
--
Bernard Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme

"Trevor Little" Trevor wrote in message
...
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)