Please see the file attached.
I have added up the largest and fourth largest value in table I in each of rows 3, 4 and 5 as shown in column P.
Now I want to add up the values in table II according to which column has been added up in table I.
In row 3, column b and d in table I has been added up in cell P3 and I want to add up column b and d in table II in cell R3.
In row 4, column a and c in table I has been added up in cell P4 and I want to add up column a and c in table II in cell R4.
In row 5, column a and f in table I has been added up in cell P5 and I want to add up column a and f in table II in cell R5.
What formula should I set in cell R3 such that I can drag down the column to yield my desired result in every cell in column R?
Please avoid excel VBA as far as possible in the solution.
Thanks in advance.
Excel.xls
Bookmarks