Formula Required

[abuShasan]

TARGET ANALYSIS.xlsx
	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q	R	S	T
1	FOR THE MONTH OF JANUARY 2022
2	INV.	Date	Customer	Place Of Supply	GSTIN	HSN	GST	Pcs	Value	Discount	Transport	Taxable	SGST		CGST		IGST		Invoice	Type
3	No.					Code	Rate				Charges	Value	Rate	Amount	Rate	Amount	Rate	Amount	Value
4
5	NO OF INVOICES SUB TOTAL			18		SUB TOTAL		69	392535.00	0.00	0.00	392535.00		5256.17		5256.17		9114.46	412163.00
6	NO OF INVOICES TOTAL			18		TOTAL		69	392535.00	0.00	0.00	392535.00		5256.17		5256.17		9114.46	412163.00
7	GST/21-22/371	1/Jan/22	CASH b2cs	27-Maharashtra	27x UNREGISTERED	41071200	5.00	2	7852.50			7852.50	2.50%	196.31	2.50%	196.31	0.00%	0.00	8245.00	b2cs
8	GST/21-22/372	2/Jan/22	Unique Furnishings	24-Gujarat	24AEOPM9168D1Z6	41071200	5.00	2	13487.50			13487.50	0.00%	0.00	0.00%	0.00	5.00%	674.38	14162.00	b2b
9	GST/21-22/373	3/Jan/22	Royal Interiors	27-Maharashtra	27AAJPK7686H1Z4	41071200	5.00	3	19538.75			19538.75	2.50%	488.47	2.50%	488.47	0.00%	0.00	20516.00	b2b
10	GST/21-22/374	4/Jan/22	Syed Hashim Akbar Hussaini	36-Telengana	36x UNREGISTERED	41071200	5.00	3	18500.00			18500.00	0.00%	0.00	0.00%	0.00	5.00%	925.00	19425.00	b2cs
11	GST/21-22/375	4/Jan/22	CASH b2cs	27-Maharashtra	27x UNREGISTERED	41071200	5.00	3	10957.50			10957.50	2.50%	273.94	2.50%	273.94	0.00%	0.00	11505.00	b2cs
12	GST/21-22/376	5/Jan/22	Unique Furnishings	24-Gujarat	24AEOPM9168D1Z6	41071200	5.00	4	26812.50			26812.50	0.00%	0.00	0.00%	0.00	5.00%	1340.63	28153.00	b2b
13	GST/21-22/377	6/Jan/22	Unique Furnishings	24-Gujarat	24AEOPM9168D1Z6	41071200	5.00	1	14062.50			14062.50	0.00%	0.00	0.00%	0.00	5.00%	703.13	14766.00	b2b
14	GST/21-22/378	7/Jan/22	Syed Hashim Akbar Hussaini	36-Telengana	36x UNREGISTERED	41071200	5.00	6	38218.75			38218.75	0.00%	0.00	0.00%	0.00	5.00%	1910.94	40130.00	b2cs
15	GST/21-22/379	7/Jan/22	Unique Furnishings	24-Gujarat	24AEOPM9168D1Z6	41071200	5.00	8	57427.50			57427.50	0.00%	0.00	0.00%	0.00	5.00%	2871.38	60299.00	b2b
16	GST/21-22/380	7/Jan/22	Sagar Seat Covers	27-Maharashtra	27AAMPK7178H1Z6	41071200	5.00	2	11830.00			11830.00	2.50%	295.75	2.50%	295.75	0.00%	0.00	12422.00	b2b
17	GST/21-22/381	8/Jan/22	Aar Kay & Co.	27-Maharashtra	27AACPV9252B1ZM	41071200	5.00	2	15515.00			15515.00	2.50%	387.88	2.50%	387.88	0.00%	0.00	16291.00	b2b
18	GST/21-22/382	8/Jan/22	S R Luxuries	27-Maharashtra	27x UNREGISTERED	41071200	5.00	2	18777.50			18777.50	2.50%	469.44	2.50%	469.44	0.00%	0.00	19716.00	b2b
19	GST/21-22/383	8/Jan/22	CASH b2cs	27-Maharashtra	27x UNREGISTERED	41071200	5.00	3	10192.50			10192.50	2.50%	254.81	2.50%	254.81	0.00%	0.00	10702.00	b2cs
20	GST/21-22/384	10/Jan/22	Unique Furnishings	24-Gujarat	24AEOPM9168D1Z6	41071200	5.00	2	13780.00			13780.00	0.00%	0.00	0.00%	0.00	5.00%	689.00	14469.00	b2b
21	GST/21-22/385	10/Jan/22	CASH b2cs	27-Maharashtra	27x UNREGISTERED	41071200	5.00	7	30127.50			30127.50	2.50%	753.19	2.50%	753.19	0.00%	0.00	31634.00	b2cs
22	GST/21-22/386	10/Jan/22	CASH b2cs	27-Maharashtra	27x UNREGISTERED	41071200	5.00	8	35010.00			35010.00	2.50%	875.25	2.50%	875.25	0.00%	0.00	36761.00	b2cs
23	GST/21-22/387	11/Jan/22	CASH b2cs	27-Maharashtra	27x UNREGISTERED	41071200	5.00	6	25200.00			25200.00	2.50%	630.00	2.50%	630.00	0.00%	0.00	26460.00	b2cs
24	GST/21-22/388	11/Jan/22	CASH b2cs	27-Maharashtra	27x UNREGISTERED	41071200	5.00	5	25245.00			25245.00	2.50%	631.13	2.50%	631.13	0.00%	0.00	26507.00	b2cs
Sheet1

I have the above sales sheets in excel and i want to create a summary of sales depending on the customer as below

TARGET ANALYSIS.xlsx
	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q	R
1	LOCAL+CASH			KK			OMS			K2 + SS			DELHI			CUMULATIVE
2	TARGET	ACTUAL	VAR	TARGET	ACTUAL	VAR	TARGET	ACTUAL	VAR	TARGET	ACTUAL	VAR	TARGET	ACTUAL	VAR	TARGET	ACTUAL	VAR
3
Sheet2

If customer (column C sheet 1) states "KK Traders" I want to add invoice value (column S) to column E in sheet 2

If customer (column C sheet 1) states "K2 or Starshine" I want to add invoice value (column S) to column K in sheet 2

If customer (column C sheet 1) states "Hasan Impex" I want to add invoice value (column S) to column N in sheet 2

If customer (column C sheet 1) states other than "K2 or Starshine" & "Hasan Impex" and (column D sheet 1) states other than "27-Maharashtra" I want to add invoice value (column S) to column H in sheet 2

If neither of the above conditions are met then i want to add invoice value (column S) column B in sheet 2

Need help with above formula

 

[etaf]

you can do that with a nested IF , lookup or a countif()
BUT lets take
CASH b2cs, as none of your customer names exist in the list sample
Has 5 Invoice numbers
Lets pretend for sake of sample that "CASH b2cs" was "KK Traders"
Are you adding up every entry of column S for "KK Traders" on Sheet 1 and then adding it to E3 on sheet2
SUMIF()
IF ( countif(sheet1!C:C, "KK Traders" )>0 , SUMIF( Sheet1!C:C, "KK Traders" , Sheet1!S:S) +E3 , IF ( next customer

will there only be 1 row on sheet2

What cell is this formula going into on sheet2

 

[bbrnx19]

Welcome , as you did not mention summation of invoices

Book1
	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q	R
1	LOCAL+CASH			KK			OMS			K2 + SS			DELHI			CUMULATIVE
2	TARGET	ACTUAL	VAR	TARGET	ACTUAL	VAR	TARGET	ACTUAL	VAR	TARGET	ACTUAL	VAR	TARGET	ACTUAL	VAR	TARGET	ACTUAL	VAR
3		8245			0			0			0			0
4		0			0			14162			0			0
5		20516			0			0			0			0
6		0			0			19425			0			0
7		11505			0			0			0			0
8		0			0			28153			0			0
9		0			0			14766			0			0
10		0			0			40130			0			0
11		0			0			60299			0			0
12		12422			0			0			0			0
13		16291			0			0			0			0
14		19716			0			0			0			0
15		10702			0			0			0			0
16		0			0			14469			0			0
17		31634			0			0			0			0
18		36761			0			0			0			0
19		26460			0			0			0			0
20		26507			0			0			0			0
Sheet2

Cell Formulas
Range	Formula
B3:B20	B3	=IF(AND(E3=0,H3=0,K3=0,N3=0),Sheet1!S7,0)
E3:E20	E3	=IF(Sheet1!C7="KK Traders",Sheet1!S7,0)
H3:H20	H3	=IF(AND(OR(Sheet1!C7<>"K2 ",Sheet1!C7<>"Starshine",Sheet1!C7<>"Hasan Impex"),Sheet1!D7<>"27-Maharashtra"),Sheet1!S7,0)
K3:K20	K3	=IF(OR(Sheet1!C7="K2 ",Sheet1!C7="Starshine"),Sheet1!S7,0)
N3:N20	N3	=IF(Sheet1!C7="Hasan Impex",Sheet1!S7,0)