I have a table (see file) which shows different arrival dates for Products A to D.
I want to bring quantities across to the other table, for example, if quantity D has two shipments arriving in May, the total of the two shipments will appear under the column May, and so on.
I am trying to use an IF formula, but am stuck.
Any help is appreciated.
Thank you in advance. Book2.xlsx