Solved

IF Formula.....

Posted on 2011-03-21
3
340 Views
Last Modified: 2012-06-27
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
Comment
Question by:Farah Mohammed
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
3 Comments
 
LVL 33

Accepted Solution

by:
jppinto earned 450 total points
ID: 35184817
Please take a look at the attached solution...

jppinto
Book2-1-.xlsx
0
 
LVL 59

Assisted Solution

by:Chris Bottomley
Chris Bottomley earned 50 total points
ID: 35186882
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
 

Author Closing Comment

by:Farah Mohammed
ID: 35190680
Thank you for both your help... I realised that using IF was probably not the way to go.
0

Featured Post

Get MySQL database support online, now!

At Percona’s web store you can order your MySQL database support needs in minutes. No hassles, no fuss, just pick and click. Pay online with a credit card.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

You need to know the location of the Office templates folder, so that when you create new templates, they are saved to that location, and thus are available for selection when creating new documents.  The steps to find the Templates folder path are …
Ever visit a website where you spotted a really cool looking Font, yet couldn't figure out which font family it belonged to, or how to get a copy of it for your own use? This article explains the process of doing exactly that, as well as showing how…
This Micro Tutorial will demonstrate in Microsoft Excel how to add style and sexy appeal to horizontal bar charts.
Do you want to know how to make a graph with Microsoft Access? First, create a query with the data for the chart. Then make a blank form and add a chart control. This video also shows how to change what data is displayed on the graph as well as form…

632 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question