Go Premium for a chance to win a PS4. Enter to Win

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 343
  • Last Modified:

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
0
Farah Mohammed
Asked:
Farah Mohammed
2 Solutions
 
jppintoCommented:
Please take a look at the attached solution...

jppinto
Book2-1-.xlsx
0
 
Chris BottomleyCommented:
The following uses sumifs if that is a consideration for using if ... i.e.

=SUMIFS($B:$B,$A:$A,$F3,$D:$D,G$2)

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

Chris
Book2-1-.xlsx
0
 
Farah MohammedBuyerAuthor Commented:
Thank you for both your help... I realised that using IF was probably not the way to go.
0

Featured Post

What is SQL Server and how does it work?

The purpose of this paper is to provide you background on SQL Server. It’s your self-study guide for learning fundamentals. It includes both the history of SQL and its technical basics. Concepts and definitions will form the solid foundation of your future DBA expertise.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now