Average sales quantity with conditions

[kmonkmol]

Hi Sir
Please note following Table i have data of One Month Sales and return quantity and Price, I need Show Monday AVERAGE Net Sales Quantity(Sales minus Return) with condition(if Customer code, Item Code) is Same

[TABLE="width: 679"]
<tbody>[TR]
[TD]TRANScode[/TD]
[TD]DATE[/TD]
[TD]CST CODE[/TD]
[TD]ITEM CODE[/TD]
[TD]SALES QTY[/TD]
[TD]SALES PRICE[/TD]
[TD]RTN QTY[/TD]
[TD]RTN PRICE[/TD]
[/TR]
[TR]
[TD]SALES[/TD]
[TD="align: right"]01-09-2017[/TD]
[TD]ALM2118[/TD]
[TD]A1003[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]8.4[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[/TR]
[TR]
[TD]SALES[/TD]
[TD="align: right"]01-09-2017[/TD]
[TD]ALM2118[/TD]
[TD]A1002[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]16.2[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[/TR]
[TR]
[TD]SALES[/TD]
[TD="align: right"]01-09-2017[/TD]
[TD]ALM1685[/TD]
[TD]A1003[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]8.4[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[/TR]
[TR]
[TD]SALES[/TD]
[TD="align: right"]01-09-2017[/TD]
[TD]ALM1685[/TD]
[TD]A1002[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]8.1[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[/TR]
[TR]
[TD]SALES[/TD]
[TD="align: right"]02-09-2017[/TD]
[TD]ALM1685[/TD]
[TD]A1002[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]16.2[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[/TR]
[TR]
[TD]SALES[/TD]
[TD="align: right"]02-09-2017[/TD]
[TD]ALM1685[/TD]
[TD]A1003[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]8.4[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[/TR]
[TR]
[TD]SALES[/TD]
[TD="align: right"]02-09-2017[/TD]
[TD]WZS1020F[/TD]
[TD]A1002[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]16.5[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[/TR]
[TR]
[TD]SALES[/TD]
[TD="align: right"]02-09-2017[/TD]
[TD]WZS1020F[/TD]
[TD]A1003[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]17.5[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[/TR]
[TR]
[TD]SALES[/TD]
[TD="align: right"]02-09-2017[/TD]
[TD]ALM2118[/TD]
[TD]A1002[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]16.2[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[/TR]
[TR]
[TD]SALES[/TD]
[TD="align: right"]02-09-2017[/TD]
[TD]ALM2118[/TD]
[TD]A1003[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]16.8[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[/TR]
[TR]
[TD]SALES[/TD]
[TD="align: right"]03-09-2017[/TD]
[TD]ALM1685[/TD]
[TD]A1002[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]16.2[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[/TR]
[TR]
[TD]SALES[/TD]
[TD="align: right"]03-09-2017[/TD]
[TD]ALM2118[/TD]
[TD]A1002[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]16.2[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[/TR]
[TR]
[TD]SALES[/TD]
[TD="align: right"]03-09-2017[/TD]
[TD]ALM2118[/TD]
[TD]A1003[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]8.4[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[/TR]
[TR]
[TD]SALES[/TD]
[TD="align: right"]03-09-2017[/TD]
[TD]WZS1020F[/TD]
[TD]A1002[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]16.5[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[/TR]
[TR]
[TD]SALES[/TD]
[TD="align: right"]03-09-2017[/TD]
[TD]WZS1020F[/TD]
[TD]A1003[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]17.5[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[/TR]
[TR]
[TD]SALES[/TD]
[TD="align: right"]04-09-2017[/TD]
[TD]WZS1020F[/TD]
[TD]A1002[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]8.25[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[/TR]
[TR]
[TD]SALES[/TD]
[TD="align: right"]04-09-2017[/TD]
[TD]WZS1020F[/TD]
[TD]A1003[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]8.75[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[/TR]
[TR]
[TD]SALES[/TD]
[TD="align: right"]04-09-2017[/TD]
[TD]ALM2118[/TD]
[TD]A1003[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]8.4[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[/TR]
[TR]
[TD]SALES[/TD]
[TD="align: right"]05-09-2017[/TD]
[TD]WZS1020F[/TD]
[TD]A1002[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]16.5[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[/TR]
[TR]
[TD]SALES[/TD]
[TD="align: right"]05-09-2017[/TD]
[TD]WZS1020F[/TD]
[TD]A1003[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]8.75[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[/TR]
[TR]
[TD]SALES[/TD]
[TD="align: right"]05-09-2017[/TD]
[TD]ALM1685[/TD]
[TD]A1002[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]8.1[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[/TR]
[TR]
[TD]SALES[/TD]
[TD="align: right"]05-09-2017[/TD]
[TD]ALM2118[/TD]
[TD]A1002[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]16.2[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[/TR]
[TR]
[TD]SALES[/TD]
[TD="align: right"]05-09-2017[/TD]
[TD]ALM2118[/TD]
[TD]A1003[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]8.4[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[/TR]
[TR]
[TD]SALES[/TD]
[TD="align: right"]03-09-2017[/TD]
[TD]ZOM4002[/TD]
[TD]A1002[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]8.25[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[/TR]
[TR]
[TD]SALES[/TD]
[TD="align: right"]05-09-2017[/TD]
[TD]ZOM4002[/TD]
[TD]A1002[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]8.25[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[/TR]
[TR]
[TD]RETURN[/TD]
[TD="align: right"]01-09-2017[/TD]
[TD]ALM2118[/TD]
[TD]A1003[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]16.8[/TD]
[/TR]
[TR]
[TD]RETURN[/TD]
[TD="align: right"]01-09-2017[/TD]
[TD]ALM1685[/TD]
[TD]A1002[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]8.1[/TD]
[/TR]
[TR]
[TD]RETURN[/TD]
[TD="align: right"]02-09-2017[/TD]
[TD]ALM2118[/TD]
[TD]A1002[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]8.1[/TD]
[/TR]
[TR]
[TD]RETURN[/TD]
[TD="align: right"]02-09-2017[/TD]
[TD]ALM2118[/TD]
[TD]A1003[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]8.4[/TD]
[/TR]
[TR]
[TD]RETURN[/TD]
[TD="align: right"]05-09-2017[/TD]
[TD]ALM1685[/TD]
[TD]A1003[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]8.4[/TD]
[/TR]
</tbody>[/TABLE]

 

[AhoyNC]

Maybe something like this:
This is an array formula and must be entered with CTRL-SHIFT-ENTER.

Excel Workbook
	A	B	C	D	E	F	G	H	I	J	K	L	M
1	TRANScode	DATE	CST CODE	ITEM CODE	SALES QTY	SALES PRICE	RTN QTY	RTN PRICE		Day	CST	Item	Average
2	SALES	9/1/2017	ALM2118	A1003	1	8.4	0	0		Monday	WZS1020F	A1002	8.25
3	SALES	9/1/2017	ALM2118	A1002	2	16.2	0	0		Monday	ALM2118	A1003	8.4
4	SALES	9/1/2017	ALM1685	A1003	1	8.4	0	0
5	SALES	9/1/2017	ALM1685	A1002	1	8.1	0	0
6	SALES	9/2/2017	ALM1685	A1002	2	16.2	0	0
7	SALES	9/2/2017	ALM1685	A1003	1	8.4	0	0
8	SALES	9/2/2017	WZS1020F	A1002	2	16.5	0	0
9	SALES	9/2/2017	WZS1020F	A1003	2	17.5	0	0
10	SALES	9/2/2017	ALM2118	A1002	2	16.2	0	0
11	SALES	9/2/2017	ALM2118	A1003	2	16.8	0	0
12	SALES	9/3/2017	ALM1685	A1002	2	16.2	0	0
13	SALES	9/3/2017	ALM2118	A1002	2	16.2	0	0
14	SALES	9/3/2017	ALM2118	A1003	1	8.4	0	0
15	SALES	9/3/2017	WZS1020F	A1002	2	16.5	0	0
16	SALES	9/3/2017	WZS1020F	A1003	2	17.5	0	0
17	SALES	9/4/2017	WZS1020F	A1002	1	8.25	0	0
18	SALES	9/4/2017	WZS1020F	A1003	1	8.75	0	0
19	SALES	9/4/2017	ALM2118	A1003	1	8.4	0	0
20	SALES	9/5/2017	WZS1020F	A1002	2	16.5	0	0
21	SALES	9/5/2017	WZS1020F	A1003	1	8.75	0	0
22	SALES	9/5/2017	ALM1685	A1002	1	8.1	0	0
23	SALES	9/5/2017	ALM2118	A1002	2	16.2	0	0
24	SALES	9/5/2017	ALM2118	A1003	1	8.4	0	0
25	SALES	9/3/2017	ZOM4002	A1002	1	8.25	0	0
26	SALES	9/5/2017	ZOM4002	A1002	1	8.25	0	0
27	RETURN	9/1/2017	ALM2118	A1003	0	0	2	16.8
28	RETURN	9/1/2017	ALM1685	A1002	0	0	1	8.1
29	RETURN	9/2/2017	ALM2118	A1002	0	0	1	8.1
30	RETURN	9/2/2017	ALM2118	A1003	0	0	1	8.4
31	RETURN	9/5/2017	ALM1685	A1003	0	0	1	8.4
Sheet

 

[kmonkmol]

Hi AhoyNC
This formula is work for me Thank You Very much.

 

[smozgur]

This formula is work for me Thank You Very much.

The marked solution has been changed accordingly. In your future questions, please mark the post as the solution that actually answered your question, instead of your feedback message as it will help future readers. No further action is required for this thread.