Thursday, August 9, 2012

yogi_Parse Out Alpha Numeric Characters Sum The Numbers And Count The Alphabets As Specified

Yogi Anand, D.Eng, P.E.       Google Spreadsheet    Post  #681   Aug 09, 2012

user BarbJo said: (!category-topic/docs/spreadsheets/n11li2WY_g4%5B1-25%5D)
Parsing out #s to sum based on character match
I am trying to parse out the numbers within a cell and sum if they are in front of a matching character.  (the characters denote a type of item)
for example these are cells within column
and I want to get subtotals for the each of the item types
Example answers
Subtotal for type a = 6
Subtotal for type w = 12
Subtotal type s = 6
Subtotal for type b = 15
Here is an example in the context of a spreadsheet:
Thanks to Yogi and other's examples I have two ways of getting the numerical total regardless of type.  Just can't figure out how to parse/sum to get the sum PER type.  
Can anyone help?
Thanks!  Barb
following is a solution to the problem