5

I have a Google Spreadsheet with a set of tables acting as a "database": http://prntscr.com/dbbkyv

A table with a number of persons having combinations of items in said database: http://prntscr.com/dbblhy

And finally a table summing the statistics of the different items: http://prntscr.com/dbblwe

Color code is as follows: http://prntscr.com/dbbm8w

Green cells are a dropdown list.

How could I have the sum of each stats for each person in table 3?

In this example, Person 1 should have 36 in "Stam" column, 34 in "Int" and 61 in "Spell".

Here is the Google sheet used in the example.

1
  • He has Helmet 1 and Torso 2, it equals to 36. I'm an idiot, editing right now. Thank you.
    – Kylki
    Nov 24, 2016 at 23:18

1 Answer 1

3

You might try, in B21, C21 and D21 in order:

=vlookup(vlookup($A21;$A$13:$C$16;column();0);$A$4:$D$6;column();0)+vlookup(vlookup($A21;$A$13:$C$16;column()+1;0);$F$4:$I$6;column();0)  

=vlookup(vlookup($a21;$a$13:$c$16;column()-1;0);$a$4:$d$6;column();0)+vlookup(vlookup($a21;$a$13:$c$16;column();0);$f$4:$i$6;column();0)  

=vlookup(vlookup($a21;$a$13:$c$16;column()-2;0);$a$4:$d$6;column();0)+vlookup(vlookup($a21;$a$13:$c$16;column()-1;0);$f$4:$i$6;column();0  

This is complexity purely resulting from the layout you chose.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.