IF Formula.....

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
Farah MohammedBuyerAsked:
Who is Participating?
jppintoConnect With a Mentor Commented:
Please take a look at the attached solution...

Chris BottomleyConnect With a Mentor Commented:
The following uses sumifs if that is a consideration for using if ... i.e.


It cannot be done, (just watch someone prove otherwise!) with a simple if due to the twin conditions of month and product.

Farah MohammedBuyerAuthor Commented:
Thank you for both your help... I realised that using IF was probably not the way to go.
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.