Good afternoon, I was hoping you all could assist with the following problem. I have tried to outline the situation below. "Sheet 1" is the table of data. "Sheet 2" is where I would like to sum the second row of each set. Currently, I am able to sum the first row no problem using sumproduct and index. Is there another solution to sum the second row instead? Please let me know if I can provide additional information. TIA.
"Sheet 1"
<colgroup><col width="64" span="4" style="width:48pt"> </colgroup><tbody>
</tbody>
"Sheet 2"
A =SUMPRODUCT((Sheet1!A2:A12=Sheet2!A2)*INDEX(Sheet1!B2:D12,0,1):INDEX(Sheet1!B2:D12,1,0))
A = 60
Want A to = 15
"Sheet 1"
A1 | B1 | C1 | D1 |
A | 10 | 20 | 30 |
5 | 5 | 5 | |
1 | 1 | 1 | |
B | 5 | 5 | 5 |
1 | 1 | 1 | |
10 | 10 | 10 | |
C | 1 | 1 | 1 |
10 | 10 | 10 | |
5 | 5 | 5 |
<colgroup><col width="64" span="4" style="width:48pt"> </colgroup><tbody>
</tbody>
"Sheet 2"
A =SUMPRODUCT((Sheet1!A2:A12=Sheet2!A2)*INDEX(Sheet1!B2:D12,0,1):INDEX(Sheet1!B2:D12,1,0))
A = 60
Want A to = 15