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.
najim_uddin From you current sample you can use below formula-
=INDEX(Distributor1!$G$20:$J$20,MATCH(A2,Distributor1!$G$2:$J$2,0))+INDEX(Distributor2!$G$20:$J$20,MATCH(A2,Distributor2!$G$2:$J$2,0))
If you are an user of Microsoft 365 insiders/current preview channel then could try-
=SUM(INDEX(VSTACK(Distributor1!$G$3:$J$19,Distributor2!$G$3:$J$19),,MATCH(A2,{"A","B","C","D"},0)))
- Thanks Harun24HR , its working.
