Using SumIf to create monthly total. Qty and Date next to each other on row.

Hello,

I have an interesting challenge which I am unable to solve.

My data runs across (attached data set larger in attached file).

Data Below

123ABC-ZZ 10 2/13/2019 10 2/20/2019 30 2/27/2019 50 3/13/2019 20 3/27/2019 30
456DEF-ZZ 30 2/13/2019 30 2/20/2019 20 2/27/2019 20 3/6/2019 10 3/13/2019 30 100 1/4/2020 50 2/14/2020

Output I require:

Jan-19 Feb-19 Mar-19 Apr-19 May-19 Jun-19 Jul-19 Aug-19 Sep-19 Oct-19 Nov-19 Dec-19 Jan-20 Feb-20
123ABC-ZZ 50 70
456DEF-ZZ 80 70 100 50


Example.PNG

Results can be set up in a different tab. I can also setup template of numbers to drive results on row. I just can't figure out how to total the quantities next to the date into one cell.

Thank you in advance,
Joe

Good morning Ford,

Thank you very much for your quick reply and solution. I really appreciate your expertise and help.
It works perfectly based on my sample data and thank you for the suggestion regarding the setup of raw data.
Unfortunately, the raw data out is provided in this manner across rather than down.

I will take a closer look at the formula to better understand it so I can use it for future scenarios.

In the meantime, I can work with the data based on your solution.
Thank you again very much!
Have a great day and week ahead,
Joe