CODEWITHSUNDEEP
excelfunctionsumformulakey-value
Matthias Reisner
Matthias Reisner

Reputation: 579

Calculate Sum with cells that contain a string that stands for a specific value

I want to solve the following.

In Cell A1 i type "S". In Cell B1 i type "U". Now I want to define a key value table somewhere on the excelsheet -> (S=8;U=3) If I create a sum function for cell A to B the result should be 11.

Upvotes: 0

Views: 590

Answers (1)

barry houdini
barry houdini

Reputation: 46341

If you create a table with letters in Y2:Y10 and then corresponding amounts in Z2:Z10 then you can use this formula to get 11

=SUMPRODUCT(SUMIF(Y2:Y10,A1:B1,Z2:Z10))

Upvotes: 2

Related Questions