CODEWITHSUNDEEP
excelsumifs
Ivan
Ivan

Reputation: 38

EXCEL!! Multiple SUMIFS with multiple criterias

So I got a 2 tables, in table 1 cells look like this

http://i.imgur.com/vt6ZxoE.jpg

What I need is a formula that will sum the values out of Column A for each letter (even if they repeat themselves throughout different columns) and put them in a table like this bellow

enter image description here

So the end result should look like this:

http://i.imgur.com/5Op5ZcS.jpg

Just please have in mind this is a table of a couple of hundreds rows and 10 columns

Thank you!

Upvotes: 1

Views: 195

Answers (1)

Ron Rosenfeld
Ron Rosenfeld

Reputation: 60414

Assuming your value for H is incorrect and should really be 4, try this formula in Table2 Sumvalues Row 1 (A9 above)

=SUMPRODUCT((Table1[[T1]:[T4]]=Table2[[#This Row],[LETTER]])*Table1[Value])

Upvotes: 2

Related Questions