Alphabet Value Compare Calculation

[DeepMa1]

Hi All,

In attached excel column A has Alphabets & column B has Numbers.
I need formula or macro to the the output in column D.
What ever the Alphabets I enter from column E it should refer that alphabet in column A and get its corresponding number and sum it and give the output. Check from column E till it finds the empty cell it should keep compare and sum the corresponding value and given the output.

TIA.

[JohnTopley]

Please Login or Register  to view this content.

in D2

=sum_alpha($B$2:$B$27,$E2:$Z2)

Copy down

Change higlighted range as required

OR

Please Login or Register  to view this content.

in D2

=sum_alpha($E2:$Z2)

List of numbers (column B) is named range "Numbers"

[windknife]

D2

Please Login or Register  to view this content.

copied down.

[Pete_UK]

In cell A10 you have "I ", i.e. I followed by a space, and in A19 you have "R " - you need to remove those spaces, then you can use this array* formula:

=SUM(SUMIFS($B$2:$B$27,$A$2:$A$27,$E2:$O2))

* Note that in XL2016, which your profile states that you are using, you need to commit the formula using the key combination of Ctrl-Shift-Enter, rather than the usual Enter.

Copy the formula down as required.

Hope this helps.

Pete

[HansDouwe]

Please try in D2 and copy down:

Please Login or Register  to view this content.

[DeepMa1]

Please try in D2 and copy down:

Please Login or Register  to view this content.

This is Solved

[HansDouwe]

Thanks for your feedback, Glad to have helped.

Please consider adding reputation to any helpers you think they deserve.
In that case please click * Add Reputation left below their answers.