Thread
:
Summing Cells with Text and Numbers
View Single Post
#
1
January 12th, 2010, 07:59 PM 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)
Trevor Little
View Public Profile
View message headers
Find all posts by Trevor Little
Find all threads started by Trevor Little