SUM and Filter Formula

[ChetanPuri]

Dear Excel Experts,

Can you please advise what am I doing wrong here. I am trying to create a summaryy by Work ID, then codes column Aand then matching the headerss. Any hep will be appreciated.
Many thanks,

V17 BAS Review 05 December 2024.xlsm
	A	B	C	D	E
1		Period	JUL24	AUG24
2		Costing Work ID	10	Monthly
3	CODES		Ex GST	GST Amount	GST Inclusive
4	GST Codes - Purchase	BAS Codes	$ 0	$ 0	$ 0
5	A1	G11	#VALUE!	$0.00	$0.00
6	A2	G14	$0.00	$0.00	$0.00
7	A4	G15	$0.00	$0.00	$0.00
8	A5	G10	$0.00	$0.00	$0.00
9	C1	G1	$0.00	$0.00	$0.00
10	S1	G2	$0.00	$0.00	$0.00
11	S2		$0.00	$0.00	$0.00
12	Total		#VALUE!	$0.00	$0.00
BAS SUMMARY _MONTHLY

Cell Formulas
Range	Formula
C5	C5	=SUM(FILTER('GST Reconciliation'!$D$4:$F$33,('GST Reconciliation'!$D$2='BAS SUMMARY _MONTHLY'!$C$2)*('GST Reconciliation'!$A$5:$A$33,'BAS SUMMARY _MONTHLY'!A5)))
C12:E12	C12	=SUM(C5:C11)

Cells with Data Validation
Cell	Allow	Criteria
C1:D1	List	='All Transaction'!$F:$F

V17 BAS Review 05 December 2024.xlsm
	A	B	C	D	E	F
1			Period	JUL24	SEP24
2			Costing Work ID	10	Monthly
3	CODES		Transaction Type	Ex GST	GST Amount	GST Inclusive
4	GST Codes - Purchase	BAS Codes		$ 0	$ 0	$ 0
5	A0	Not Required For BAS	AP INV	$ 2,060,521	$ 10,877	$ 2,071,398
6	A0	Not Required For BAS	DR DBT	$ 0	$ 0	$ 0
7	A0	Not Required For BAS	AP CRD	($ (1,623,255))	$ 0	($ (1,623,255))
8	A0	Not Required For BAS	AP PPI	$ 29,432	$ 0	$ 29,432
9	A0	Not Required For BAS	AP PPC	($ (11,550))	$ 0	($ (11,550))
10	A1	G11	AP INV	$ 25,029,828	$ 2,502,983	$ 27,532,811
11	A1	G11	AP CRD	($ (173,748))	($ (17,375))	($ (191,123))
12	A1	G11	DR DBT	$ 0	$ 0	$ 0
13	A1	G11	AR ADJ	$ 0	$ 0	$ 0
14	A1	G11	AP PPC	$ 1,268	$ 127	$ 1,394
15	A1	G11	AP PPI	$ 552	$ 55	$ 607
16	A2	G14	AP PPI	$ 234	$ 0	$ 234
17	A2	G14	AP INV	$ 248,035	$ 0	$ 248,035
18	A2	G14	AP CRD	($ (50,914))	$ 0	($ (50,914))
19	A4	G15	AP INV	$ 4,280	$ 0	$ 4,280
20	A4	G15	AP CRD	($ (7))	$ 0	($ (7))
21	A5	G10	AP INV	$ 0	$ 0	$ 0
22	C1	G1	G JNL	$ 0	$ 0	$ 0
23	C1	G1	AP PPI	$ 0	$ 0	$ 0
24	S0	G3	AR INV	$ 0	$ 0	$ 0
25	S0	G3	AR ADJ	$ 0	$ 0	$ 0
26	S0	G3	G JNL	$ 0	$ 0	$ 0
27	S0	G3	AR CSH	$ 0	$ 0	$ 0
28	S1	G2	AR INV	$ 0	$ 0	$ 0
29	S1	G2	AR ADJ	$ 0	$ 0	$ 0
30	S1	G2	AR CRD	($ (0))	$ 0	($ (0))
31	S1	G2	AR CSH	$ 0	$ 0	$ 0
32	S1	G2	G JNL	$ 0	$ 0	$ 0
33	S2		AR INV	$ 0	$ 0	$ 0
34	Total			$ 25,514,677	$ 2,496,667	$ 28,011,344
GST Reconciliation

Cell Formulas
Range	Formula
D34	D34	=SUM($D$4:$D$33)
E34	E34	=SUM($E$4:$E$33)
F34	F34	=SUM($F$4:$F$33)

Cells with Data Validation
Cell	Allow	Criteria
D1:E1	List	='All Transaction'!$F:$F

 

[ChetanPuri]

Delete formulas in column D and E.

Thank you for your response , but I get this

 

[Cubist]

Again,clear out the cells in column D and E. Which part don't you understand?

spill error - Google Search

 

[ChetanPuri]

Again,clear out the cells in column D and E. Which part don't you understand?

spill error - Google Search

It worked thank you much appreciated for all your help