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     www.energyefficientbuild.com.

user BarbJo said: (http://productforums.google.com/forum/?zx=p0ja4375k56r#!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

3w2b3a4s
3w5b3a
6w8b2s

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:  https://docs.google.com/

spreadsheet/ccc?key=
0ArPWVm5KqplmdEVfNmk1bVNXT1VBRkFrX0w5QmkyaEE 

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