Quantity of items in certain month using system timestamp

Hi There,

I am hoping someone can help me!

I am working with an inventory system that time stamps every time an item is used and also includes the quantity.

I am trying to build a spreadsheet off the back of this but am struggling with a formula to get what i need.

So in Cell G2 I am trying to get it to tell me how many "A Packs" have been used in the month of June, so it should calculate 7

I have tried the below but obviously not correct, i have tried a few different options but cant quite get there, i dont think i can change the formatting of Column A as that's how the system updates it

=SUMIFS(C2:C19,B2:B19,J2,A2:A19,">="&DATE(2023,6,1),A2:C19,"<="&DATE(2023,6,31))

Brilliant, this worked perfectly, also a schoolboy error from me with the space, well spotted!

Thank you so much

another method by using sumproduct

G2
=SUMPRODUCT((C2:C19)*(TRIM(B2:B19)=J2)*(MONTH(A2:A19)=MONTH(G1)))