Need Help to Correct the formula

[RAJESH1960]

Hello ,
In my sample data it was working fine. But when I tried in my original data it is not working.
I have changed the range in the formula in the first row only. I am getting the right answer. If I drag down the formula to 1000 rows, I am getting an error from the 2nd row onwards. I tried unlocking the freeze cells but it ain’t working. What could be the problem.?. I would really appreciate if someone can tell me or correct the formula for the “J” column. The rest of the columns I could change accordingly.

Query to sort multiple data horizontally.xlsx
	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q	R	S	T
1	DATE	PARTICULARS	NUMBER	Helper	DEBIT	CREDIT		Voucher No.	1	Amt	2	Amt	3	Amt	4	Amt	5	Amt	6	Amt
2	01-02-2021	January	8115	1	-3792			8115	January	-3792		0		0		0		0		0
3	01-02-2021	February	8116	1	-8380			8116	January	0		0		0		0		0		0
4	01-02-2021	March	8117	1	-9600			8117	March	-9600		0		0		0		0		0
5	01-02-2021	April	8118	1	-1970			8118	April	-1970		0		0		0		0		0
6	01-02-2021	May	8119	1	-8165			8119	May	-8165		0		0		0		0		0
7	01-02-2021	June	8120	1	-13063			8120	June	-13063		0		0		0		0		0
8	01-02-2021	July	8121	1	-15000			8121	July	-15000	August	645	September	10015	October	1056	November	2600	December	684
9	01-02-2021	August	8121	2	0	645		4348	January	10000		0		0		0		0		0
10	01-02-2021	September	8121	3	0	10015		4349	February	4000		0		0		0		0		0
11	01-02-2021	October	8121	4	0	1056		1490	March	-15000		0		0		0		0		0
12	01-02-2021	November	8121	5	0	2600		8144		0		0		0		0		0		0
13	01-02-2021	December	8121	6	0	684		8145		0		0		0		0		0		0
14	02-02-2021	January	4348	1	0	10000		8146		0		0		0		0		0		0
15	02-02-2021	February	4349	1	0	4000		8147		0		0		0		0		0		0
16	02-02-2021	March	1490	1	-15000			8148		0		0		0		0		0		0
17	02-02-2021	April	8144	1	-14850			8149		0		0		0		0		0		0
18	02-02-2021	May	8145	1	-14000			8150		0		0		0		0		0		0
19	02-02-2021	June	8146	1	-1756			8151		0		0		0		0		0		0
20	02-02-2021	July	8147	1	-6406			8152		0		0		0		0		0		0
21	02-02-2021	August	8147	2	0	6405		8153		0		0		0		0		0		0
22	02-02-2021	September	8147	3	0	1		8154		0		0		0		0		0		0
23	02-02-2021	October	8148	1	-23650			8155		0		0		0		0		0		0
24	02-02-2021	November	8149	1	-13905			8156		0		0		0		0		0		0
25	02-02-2021	December	8150	1	-7389			8157		0		0		0		0		0		0
26	02-02-2021	January	8151	1	-2455			4355		0		0		0		0		0		0
27	02-02-2021	February	8152	1	-7053			1492		0		0		0		0		0		0
28	02-02-2021	March	8153	1	-1290			4358		0		0		0		0		0		0
29	02-02-2021	April	8154	1	-3270			1493		0		0		0		0		0		0
30	02-02-2021	May	8155	1	-7515			8165		0		0		0		0		0		0
31	02-02-2021	June	8156	1	-7000			8166		0		0		0		0		0		0
32	02-02-2021	July	8156	2	0	6645		4359		0		0		0		0		0		0
33	02-02-2021	August	8156	3	0	355		8167		0		0		0		0		0		0
34	02-02-2021	September	8157	1	-3000			8168		0		0		0		0		0		0
35	03-02-2021	October	4355	1	0	10868		8169		0		0		0		0		0		0
36	03-02-2021	November	1492	1	-2500			8170		0		0		0		0		0		0
37	03-02-2021	December	4358	1	0	1180		8171		0		0		0		0		0		0
38	03-02-2021	January	4358	2	-236			8172		0		0		0		0		0		0
39	03-02-2021	February	4358	3	-236			4360		0		0		0		0		0		0
40	03-02-2021	March	4358	4	-236			4361		0		0		0		0		0		0
41	03-02-2021	April	4358	5	-236			4362		0		0		0		0		0		0
42	03-02-2021	May	4358	6	-236			4379		0		0		0		0		0		0
Solved

Cell Formulas
Range	Formula
I2:I3,S2,Q2,O2,M2,K2	I2	=IFERROR(VLOOKUP($H2&"/"&I$1,CHOOSE({1,2},$C$2:$C$2000&"/"&$D$2:$D$2000,$B$2:$B$2000),2,0),"")
J2	J2	=SUMPRODUCT(--($B$2:$B$2000=I2)*($C$2:$C$2000=H2)*($E$2:$F$2000))
L2:L42	L2	=SUMPRODUCT(--($B$2:$B$2000=K2)*($C$2:$C$2000=H2)*($E$2:$F$2000))
N2:N42	N2	=SUMPRODUCT(--($B$2:$B$2000=M2)*($C$2:$C$2000=H2)*($E$2:$F$2000))
P2:P42	P2	=SUMPRODUCT(--($B$2:$B$2000=O2)*($C$2:$C$2000=H2)*($E$2:$F$2000))
R2:R42	R2	=SUMPRODUCT(--($B$2:$B$2000=Q2)*($C$2:$C$2000=H2)*($E$2:$F$2000))
T2	T2	=SUMPRODUCT(--($B$2:$B$2000=S2)*($C$2:$C$2000=H2)*($E$2:$F$2000))
J3:J42	J3	=SUMPRODUCT(--($B$2:$B$17=I3)*($C$2:$C$17=H3)*($E$2:$F$17))
I13:I42,K3:K42,I4:I11,S3:S42,Q3:Q42,O3:O42,M3:M42	K3	=IFERROR(VLOOKUP($H3&"/"&K$1,CHOOSE({1,2},$C$2:$C$17&"/"&$D$2:$D$17,$B$2:$B$17),2,0),"")
T3:T42	T3	=SUMPRODUCT(--($B$2:$B$17=S3)*($C$2:$C$17=H3)*($E$2:$F$17))
I12	I12	=IFERROR(VLOOKUP($H12&"/"&I$1,CHOOSE({1,2},$C$2:$C$127&"/"&$D$2:$D$127,$B$2:$B$127),2,0),"")
D2:D42	D2	=IF(C1=C2,D1+1,1)
Press CTRL+SHIFT+ENTER to enter array formulas.

 

[Toadstool]

Hi Rajesh1960,

There appears to be inconsistencies in which formulae are entered with Ctr-Shift-Enter in column I and which rows are used in column J.

From your posted data edit I2 and use Ctr-Shift-Enter. Select I2 and J2 then copy down.