SUMIFS with year not working

[bootdat]

The formula im using doesnt seem to work and i cant figure out why..

POSv3-General.xlsm
	AJ	AK	AL	AM	AN	AO
3	Sales		Direct Expenses		In-direct Expenses
4	Year	Amount		Amount		Amount
5	2021	GH₵0.00		GH₵0.00		GH₵0.00
6	2022	GH₵0.00		GH₵0.00		GH₵0.00
7	2023	GH₵0.00		GH₵0.00		GH₵0.00
8	2024	GH₵0.00		GH₵0.00		GH₵0.00
9	2025	GH₵0.00		GH₵0.00		GH₵0.00
Report

Cell Formulas
Range	Formula
AK5:AK9	AK5	=SUMIFS(Table5[Sum],Table5[Date],”>=”&DATE(AJ5,1,1),Table5[Date],”<=”&DATE(AJ5,12,31))
AM5:AM9	AM5	=SUMIFS(Table14[Cost],Table14[Date],”>=”&DATE(AJ5,1,1),Table14[Date],”<=”&DATE(AJ5,12,31))
AO5:AO9	AO5	=SUMIFS(Table18[Cost],Table18[Date],”>=”&DATE(AJ5,1,1),Table18[Date],”<=”&DATE(AJ5,12,31))

SALES TABLE

POSv3-General.xlsm
	A	B	C	D	E	F	G	H
1	Invoice Number	PayMethod	Date	Qty	Item Description	Price	Sum	Cus Name
2	xxx
3	MAR2100007	MoMo	2 Mar 2021	1	7 Inch Whipped Cream Cake [Sq]	280	230	Kendrick
4	MAR2100007	MoMo	16 Mar 2021	5	Apple Pie	5	25	Kendrick
5	MAR2100007	MoMo	21 Mar 2021	1	Bread Rolls [Beef]	5	10	Kendrick
6	MAR2100007	MoMo	10 Mar 2023	2	Pound Cake	100	200	Kendrick
7	MAR2100008	Cash	22 Mar 2024	1	8 Inch Fondant Cake [Rd]	350	350	dav
Invoice Data

DIRECT EXPENSES TABLE

POSv3-General.xlsm
	A	B	C	D	E
2	Date	Source	Item Name	Qty	Cost
3
4	22-Mar-21	MoMo	Apple	52	200.00
5	22-Mar-22	Cash	Watermelon	10	400.00
6
7
8
9
Expenses

Cells with Data Validation
Cell	Allow	Criteria
B3:B158	List	='All Items'!$L$28:$L$30
C3:C158	List	='All Items'!$N$2:$N$168

IN-DIRECT EXPENSES TABLE

POSv3-General.xlsm
	H	I	J	K
2	Date	Source	Item	Cost
3
4	22-Mar-21	Cash	Advertisement (Social Media)	100.00
5	23-Mar-21	MoMo	Salary	200.00
6
Expenses

Cells with Data Validation
Cell	Allow	Criteria
I3:I42	List	='All Items'!$L$28:$L$30
J3:J42	List	='All Items'!$P$2:$P$65

May i know what seems to be the problem and how to fix it
Thanks

 

[Fluff]

You have the wrong type of quotes in your formulae, they should be like

=SUMIFS(Table5[Sum],Table5[Date],">="&DATE(AJ5,1,1),Table5[Date],"<="&DATE(AJ5,12,31))

 

[bootdat]

You have the wrong type of quotes in your formulae, they should be like

=SUMIFS(Table5[Sum],Table5[Date],">="&DATE(AJ5,1,1),Table5[Date],"<="&DATE(AJ5,12,31))

Thanks
I always seem to have challenges with the quotes.

Thanks again

 

[Fluff]

You're welcome & thanks for the feedback.