Monday, September 22, 2014

yogi_Formula In Cell B2 For Cells B2 To C To Compute Sum Of Numbers For Each Letter ID In Cells Of Column A

                      Google Spreadsheet   Post  #1765
Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI     www.energyefficientbuild.com.   Sep-22-2014
post by Medellee Antonioli:
(https://productforums.google.com/forum/#!category-topic/docs/spreadsheets/uCVHuTDhec0)
Summing numbers connected to letters
I'm trying to find a way to sum up numbers attached to a certain letter in a range of cells.  The difficulties are: 
a) Each number is attached to a letter like 20A and 
b) Each cell contains a list of numbered letters like 1A, 12B, 2D
I want my function to look at a range of cells and tell me (for example) the sum of the "A" numbers.  So if my column is:
10A, 2B
3C, 5A, 1B
2A, 2B
I want the function to output 17.  I know this would be easier if the A's, B's and C's were in separate cells, but for data entry reasons this is the way it has to be.  I've poked around a bit with regex type things, but no luck.  Any ideas?
-------------------------------------------------------------------------------------------