Sumproduct

[aarti_rto]

Hello,

i have below data..

Customer Name	Part No	Sale Price	Oct-23 (qty)	Nov-23 (qty)	Dec-23 (qty)
ABC	A	1.63	31200	15600	15600
ABC	B	49.38	31200	15600	15600
ABC	C	3.22	31200	15600	15600
XYZ	A	1.63	9600	12000	0
XYZ	B	49.38	9600	12000	0
XYZ	C	3.22	9600	12000	0
SDF	A	1.63	46800	15600	31200
SDF	B	49.38	46800	15600	31200
SDF	C	3.22	46800	15600	31200
AWE	A	1.63	19200	0	8400
AWE	B	49.38	19200	0	8400
AWE	C	3.22	19200	0	8400
QW	D	2	0	0	0
QW	E	371.31	800	3200	0

i need customer wise monthly value ( Sale price * respective month qty)

below samples of 2 customers expected answer..

Customer Name			Value of Oct-23	Value of Nov-23	Value of Dec-23
ABC			1691976​	845988​	845988​
XYZ			520608​	650760​	0​

 

[SunnyAlv]

Like this ?

=SUMPRODUCT(($A$2:$A$15=$H4)*($D$1:$F$1=I$3)*(($C$2:$C$15)*($D$2:$F$15)))

 

[kevin9999]

It would be easier if you use the same headings in the summary table as you have in the raw data table:

Book1
	A	B	C	D	E	F
1	Customer Name	Part No	Sale Price	Oct-23 (qty)	Nov-23 (qty)	Dec-23 (qty)
2	ABC	A	1.63	31200	15600	15600
3	ABC	B	49.38	31200	15600	15600
4	ABC	C	3.22	31200	15600	15600
5	XYZ	A	1.63	9600	12000	0
6	XYZ	B	49.38	9600	12000	0
7	XYZ	C	3.22	9600	12000	0
8	SDF	A	1.63	46800	15600	31200
9	SDF	B	49.38	46800	15600	31200
10	SDF	C	3.22	46800	15600	31200
11	AWE	A	1.63	19200	0	8400
12	AWE	B	49.38	19200	0	8400
13	AWE	C	3.22	19200	0	8400
14	QW	D	2	0	0	0
15	QW	E	371.31	800	3200	0
16
17	Customer Name	Oct-23 (qty)	Nov-23 (qty)	Dec-23 (qty)
18	ABC	1691976	845988	845988
19	XYZ	520608	650760	0
Sheet1

Cell Formulas
Range	Formula
B18:D19	B18	=SUMPRODUCT(($A$2:$A$15=$A18)*($D$1:$F$1=B$17),$D$2:$F$15*$C$2:$C$15)