Forum Discussion
Solved
INDEX MATCH AFTER THEN SUM UP THE VALUE
Hello Good People! I need help. i have attached a file having three sheets (Total, Distributor1, Distributor2). the total value of different branded products of Distributor1 sheet and Distributor...
=SUMPRODUCT((Distributor1!$G$2:$J$2=TOTAL!A2)*Distributor1!$G$3:$J$19)+SUMPRODUCT((Distributor2!$G$2:$J$2=TOTAL!A2)*Distributor2!$G$3:$J$19)You can try SUMPRODUCT.
=SUMPRODUCT((Distributor1!$G$2:$J$2=TOTAL!A2)*Distributor1!$G$3:$J$19)+SUMPRODUCT((Distributor2!$G$2:$J$2=TOTAL!A2)*Distributor2!$G$3:$J$19)You can try SUMPRODUCT.
- Thanks, OliverScheurich for your support. its working..
