I want to sum up the value for multiple lookup in the table and get their sum up value. Where i have SKU linked with another SKU and i need to know total value available.
For instance - SKU 2 122233 is part of 112131 and also 142434 , however 142434 is part of 475767 also. I want a report to tell me how much stock i have currently of 122233 - 150 and not only 50.
<colgroup><col width="64" span="7" style="width:48pt"> </colgroup><tbody>
</tbody>
<colgroup><col width="64" span="7" style="width:48pt"></colgroup><tbody></tbody>So it should give me total of
In Column F 1 i did a formula ,=IFERROR(INDEX($B$3:$B$8,MATCH(0,INDEX(COUNTIF(G$2:$G2,$B$3:$B$8),,),0)),"")
and in G1 i did =SUMIF($B$3:$B$8,G3,$F$3:$F$5)
this is not working
For instance - SKU 2 122233 is part of 112131 and also 142434 , however 142434 is part of 475767 also. I want a report to tell me how much stock i have currently of 122233 - 150 and not only 50.
A | B | C | D | E | F | |
SKU 1 | SKU 2 | Qty | SKU | Stock | SKU | |
1 | 112131 | 122233 | 1 | 122233 | 50 | 112131 |
2 | 112131 | 132333 | 1 | 142434 | 25 | 142434 |
3 | 142434 | 778899 | 1 | 475767 | 75 | 475767 |
4 | 142434 | 122233 | 1 | |||
5 | 475767 | 142434 | 1 | |||
6 | 475767 | 374757 | 1 |
<colgroup><col width="64" span="7" style="width:48pt"> </colgroup><tbody>
</tbody>
<colgroup><col width="64" span="7" style="width:48pt"></colgroup><tbody></tbody>
In Column F 1 i did a formula ,=IFERROR(INDEX($B$3:$B$8,MATCH(0,INDEX(COUNTIF(G$2:$G2,$B$3:$B$8),,),0)),"")
and in G1 i did =SUMIF($B$3:$B$8,G3,$F$3:$F$5)
this is not working