January 12th, 2010, 09:07 PM
posted to microsoft.public.excel.worksheet.functions
|
|
Summing Cells with Text and Numbers
Trevor,
With your 'numbers in a1 - d1 try this
=SUMPRODUCT((LEFT(A1 1,1)="S")*(RIGHT(A1 1,LEN(A 1 1)-1)))
Mike
"Trevor Little" wrote:
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)
|