I have a lookup table that classifies the names of columns. For example, the column names are goat, mouse, and butterfly, and the classification table shows that these column names are mammal, mammal, insect, respectively. For each row, I need to sum all columns that belong to the 'mammal' class. See picture below (my firewall may not allow the picture, so I can try again at home).
What I currently have is just returning the first column match, instead of all columns that match 'mammal'.
=sumif($B$1:$F$1, vlookup("Mammal", $K$1:$L$5, 2,0),B2:F2)
One little curve ball is that this sheet is going to be dynamic. People will be adding animal columns and classifying them in the lookup table, and I don't want them to be editing the formula.
