Adding based on month

[marcidee]

I trying to create a sales figure based on month and am not sure why the following formula is returning zero - I would appreciate if someone can help me fix

Thanks

Marc

=SUMIFS(E3:E29,A3:A29,”>=”&DATE(1,1,2022),A3:A29,”<=”&DATE(31,1,2022))

Jan​	0.00​
Feb​	0.00​
Mar​	0.00​
Apr​	0.00​
May​	0.00​

Date	Stock Name	Price	Sold QTY	Value
03/01/2022​	Amazon Echo	19.00​	4​	76.00​
09/01/2022​	Amazon Echo	19.00​	2​	38.00​
06/01/2022​	Anker Nebula	349.99​	2​	699.98​
15/02/2022​	Anker Nebula	349.99​	5​	1749.95​
07/01/2022​	BaByliss Berry Crush Straightener	28.00​	1​	28.00​
08/01/2022​	Baylis & Harding Jojoba, Vanilla & Almond Oil Luxury Bathing Duo Stack Gift Box Gift Set - Vegan Friendly…	7.49​	1​	7.49​
02/03/2022​	Canon MG3650S WH…	39.99​	1​	39.99​
10/01/2022​	CLARINS Body Care Set 3Pc	23.10​	1​	23.10​
12/02/2022​	Clementoni 39411 Clementoni-39411-Impossible Puzzle-Marvel-1000 Pieces, Multi-Colour	7.50​	2​	15.00​

 

[Fluff]

You have the values in the Date function wrong, it should be year, month,day

 

[marcidee]

Thank you for your reply - I have tried that too but this also brings a zero result?

=SUMIFS(E4:E30,A4:A30,”>=”&DATE(2022,1,1),A4:A30,”<=”&DATE(2022,1,31))

 

[Fluff]

You also have the wrong type of quotes, they should be " not ”

 

[marcidee]

That fixed it - thank you

 

[marcidee]

Hi Fluff

I just noticed If I filter out January in column 'A' it disappears in 'i' & 'J' is there a way to stop that happening?

 

[Fluff]

If you are using the autofilter, then that will hide the entire row.

 

[marcidee]

oh yes - sorry that was a silly question - thank you so much for your help

 

[Fluff]

You're welcome & thanks for the feedback.