HOW TOTAL QTY & RATE AS PER PRODUCT VISE FROM MULTIPLE SHEETS

[krunal123]

WE NEED SUMIFS FORMULA AS PER QUERY......

NOTE.: DIFFRENT-DIFFRENT SHEET IN PRODUCT POSITION IS CHANGE , HOW TO GET TOTAL QTY & RATE AS PER PRODUCTS

 

[RasGhul]

Maybe try

Book1
	A	B	C	D
1	TOTAL
2	Product	Qty	Rate	TOTAL
3	MOTOR	440	18,000	7,920,000
4	OIL SEAL	1,915	360	689,400
5	PVC PIPE	1,405	210	295,050
Sheet4

Cell Formulas
Range	Formula
B3:C5	B3	=SUMIFS(Sheet1!B$3:B$5,Sheet1!$A$3:$A$5,Sheet4!$A3)+SUMIFS(Sheet2!B$3:B$5,Sheet2!$A$3:$A$5,Sheet4!$A3)+SUMIFS(Sheet3!B$3:B$5,Sheet3!$A$3:$A$5,Sheet4!$A3)
D3:D5	D3	=B3*C3

 

[RasGhul]

or as an option

HOW TOTAL QTY & RATE AS PER PRODUCT_krunal123.xlsx
	A	B	C	D
2	Product	Qty	Rate	TOTAL
3	MOTOR	440	18000	7920000
4	OIL SEAL	1915	360	689400
5	PVC PIPE	1405	210	295050
Sheet4

Cell Formulas
Range	Formula
B3:B5	B3	=SUMPRODUCT(SUMIF(INDIRECT("'"&{"Sheet1","Sheet2","Sheet3"}&"'!$A$3:$A$5"),A3,INDIRECT("'"&{"Sheet1","Sheet2","Sheet3"}&"'!$B$3:$B$5")))
C3:C5	C3	=SUMPRODUCT(SUMIF(INDIRECT("'"&{"Sheet1","Sheet2","Sheet3"}&"'!$A$3:$A$5"),A3,INDIRECT("'"&{"Sheet1","Sheet2","Sheet3"}&"'!$C$3:$C$5")))
D3:D5	D3	=B3*C3