Thread
:
Summing Cells with Text and Numbers
View Single Post
#
1
Posted to microsoft.public.excel.worksheet.functions
Trevor Little
external usenet poster
Posts: 1
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)
Reply With Quote
Trevor Little
View Public Profile
Find all posts by Trevor Little