Trying to sum numbers for mixed cells

[GreenBee]

Hey everyone,
I'm probably posting a question that's been answered, but I haven't been able to an answer. I'm relatively new to Excel so I might be missing the proper keywords to find it.
Paired Comparison.png
I'm using a Paired Comparison Analysis chart to compare parameters. The idea is to use a combination of a character and a number in order to rank the weight of each parameter.
What I'm trying to do is to sum the numbers based on the character equivalent. That would mean that any number attached to an "A" would be added the the "A" counter, and so on for the rest of the letters.
For example, from my posted picture we would get:
"A" counter = 2
"B" counter = 3
"C" counter = 7
...

I've tried a combination of LEFT/RIGHT to isolate the numbers from the characeters,
SEARCH to determine which character is in which cell,
and ISNUMBER for boolean operations.
Without much success.
Can anyone point me in the direction of a useful formula for this? OR have I just missed the obvious with the formulae I've been using?

[Pepe Le Mokko]

Administrative note

Welcome to the forum

in your haste to solve your problem, you probably missed the yellow banner advising how to get answers faster by posting a sheet ?

Please take a moment to read it and attach a sheet accordingly.

Thanks you for helping us help you

[GreenBee]

Right, I'm very sorry that I didn't take the time to properly read the banner.
I've edited the post to attach the worksheet with some manually calculated results.

[Shareez Saleem]

Please Login or Register  to view this content.

[GreenBee]

Thanks Shareez for the quick reply!
This looks great, I'll puzzle out the formulae you've used.
However, is seems to work for columns without regard for the actual letter attached to the number.
Can you think of a way to:
1 - Differentiate counters for different letter
2 - Make it work for the entire table, not just one column?

Thanks

[AliGW]

In C11 copied down:

=SUM(IF(LEFT($C$3:$I$9,1)=RIGHT(A11,1),VALUE(MID($C$3:$I$9,2,99))))

You may need to enter the formula with CTRL+SHIFT+ENTER.

Please update your forum profile - 10 is not a valid version of Office. What are you using?

[GreenBee]

Thanks, Ali - this is exacly what I was trying to do!
I'm update my profile now.

[AliGW]

Thanks.

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.

Also, you may not be aware that you can thank those who have helped you by clicking the small star icon located in the lower left corner of the post in which the help was given. By doing so you can add to the reputation(s) of those who helped.