Solved

IF Formula.....

Posted on 2011-03-21
3
335 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:squirrelzan
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:squirrelzan
ID: 35190680
Thank you for both your help... I realised that using IF was probably not the way to go.
0

Featured Post

Complete VMware vSphere® ESX(i) & Hyper-V Backup

Capture your entire system, including the host, with patented disk imaging integrated with VMware VADP / Microsoft VSS and RCT. RTOs is as low as 15 seconds with Acronis Active Restore™. You can enjoy unlimited P2V/V2V migrations from any source (even from a different hypervisor)

Question has a verified solution.

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

Microsoft Office Picture Manager is not included in Office 2013. This comes as a shock to users upgrading from earlier versions of Office, such as 2007 and 2010, where Picture Manager was included as a standard application. This article explains how…
No matter the version of Windows you are using, you may have some problems with Windows Search running too slow or possibly not running at all. Before jumping into how you can solve this issue, just know there are many other viable alternative deskt…
Learn how to create and modify your own paragraph styles in Microsoft Word. This can be helpful when wanting to make consistently referenced styles throughout a document or template.
This Micro Tutorial will demonstrate in Google Sheets how to use the HYPERLINK function to create live links inside your spreadsheet.

910 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

Need Help in Real-Time?

Connect with top rated Experts

23 Experts available now in Live!

Get 1:1 Help Now