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 Distributor2 sheet will be summed up in Total sheet.
i am trying to solve it with index/match function.. Can you give me the formula of doing this?
Thanks in advance.
=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..
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.
