create a formula for sheet2 total column & pickup the item price form price list sheet

[rana19]

R/Sir
i am create a customer price list for different-2 items & different customers & i am add the quantity for different-2 items & different-2 customers in sheet2 than i am add the quantity for different-2 items for different-2 customers in sheet 2 & item price pickup form the pricelist sheet for different-2 customers & calculate the formula for U3 total column please send the formula for sheet2 Total column (U3)
thanking you sir

[samba_ravi]

is "MOUSE KEYBOARD DESKTOP LAPTOP MODEM HEADPHONE MONITER BATERY DVD-RW ADAPTER LED CAT5E PAPPER ANTIVIRUS CARTRIGDE HARD DISK EXT. HDD" are in same order in Sheet "PRICE LIST" and "1-9-2015" or different?

[samba_ravi]

u3=SUMPRODUCT(SUMIFS(INDEX('PRICE LIST'!$C$3:$S$5,MATCH(B3,'PRICE LIST'!$B$3:$B$5,0),),'PRICE LIST'!$C$2:$S$2,'1-9-2015'!$C$2:$S$2)*($C3:$S3))

Please Login or Register  to view this content.

Try this and copy towards down

[rana19]

r/sir
than i add next sheet & rename this sheet "2-9-2015" how can work this formula please resolve this issue sir

[samba_ravi]

=sumproduct(sumifs(index('price list'!$c$3:$s$5,match(b3,'price list'!$b$3:$b$5,0),),'price list'!$c$2:$s$2,$c$2:$s$2)*($c3:$s3))

Please Login or Register  to view this content.