Sum values based on other columns

Hi, bit of a punter here so forgive me.

I need to sum values in one column based on two others.

Column A contains product codes, Column D contains order dates and Column F contains the quantities that I would like totalled and placed in a new column.

My first issue is how to sum these (there are thousands of rows) based on each unique code in A. For example, there might be twenty rows under the code 22P1, 25 under 22P2 and onwards to 22P500.

My second is how to sum these based on order dates - specifically pre 15/01/2022, between 15/01/2022 and 30/5/2022, and on 1/6/2022 exactly.

So for each product code there would be a new summed value (of Column F) in three more columns (one for each date criteria).

Apologies if I haven't explained myself very well. I have played with SUMIFS but to be honest I'm not very clued up here. I cannot seem to attach a screenshot of the table in question.

Thanks in advance for any advice. I'm looking to understand the process as well and get a result!

Cheers.

Thank you for the help here, apologies I missed the above. Sample attached.

Thank you again for the quick reply, that is really useful. There are a couple of things I'm struggling with:

1) How would the sumifs formula recognise all duplicate product codes in Columns A?
2) Where would I enter the formula in the new columns? Would excel automatically use the cell at the bottom of each product code grouping, if I was to enter it in the first necessary cell (i.e. first product code group) and then extended it down the whole column? Or would that just populate every cell?

Sorry for questions and thanks again.

OK sorry for not making myself clear! I have updated the sample sheet, hopefully this will be better. Thank you again for your help and time.

Yes, based on the Product Groups in Column A and the date criteria specified. Thank you!

the Key is to Quote "" your Less than / Greater than criteria, and concatenate (&) with the quoted dates, too. Solution attached.

Thank you Dan!