Solved

Have a toughy formula request

Posted on 2014-01-29
2
330 Views
Last Modified: 2014-01-29
Formula I'm looking to be written is in the "orange" color, and the criteria, or cells the formula will be inquring and bringing back a result and performing a calculation is in "yellow".

So, here goes.  I have 9 meters, each having different schedules relating to IDD, Shipment, and Final Doc Stage in expected completion dates.  I need the formula in orange to engage all three categories on each and every meter and if there is a match in date(and that is the date right above the formula in orange, meaning if this date matches any of the three concepts thru all 9 meters) to multiply the % times the associated rows value in column "S".  As you can imagine you will have mulitple matches and I need to add each and every one of them and bring back the total of all of them in the cell, color coded "orange".  Good luck, I imagine I will be hearing back from you with more questions.  :)
POC-Template-3rd.xls
0
Comment
Question by:pedwards3
2 Comments
 
LVL 35

Accepted Solution

by:
mvidas earned 500 total points
ID: 39818250
pedwards3,

If I understand you correctly, enter the following formula in cell W12
=IF(W$9=$I12,$H12*$S12,0)+IF(W$9=$K12,$J12*$S12,0)+IF(W$9=$M12,$L12*$S12,0)

Then copy that formula into W12:AH20. Then in your first orange cell (W10) put =W21 as the formula and fill right.

I updated your file and attached it. If I didn't understand your request, let me know what you want differently.

Matt
POC-Template-3rd.xls
0
 

Author Closing Comment

by:pedwards3
ID: 39818370
that got the job done, thx
0

Featured Post

The Eight Noble Truths of Backup and Recovery

How can IT departments tackle the challenges of a Big Data world? This white paper provides a roadmap to success and helps companies ensure that all their data is safe and secure, no matter if it resides on-premise with physical or virtual machines or in the cloud.

Question has a verified solution.

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

Suggested Solutions

Outlook Free & Paid Tools
Some code to ensure data integrity when using macros within Excel. Also included code that helps secure your data within an Excel workbook.
This Micro Tutorial demonstrates using Microsoft Excel pivot tables, how to reverse engineer competitors' marketing strategies through backlinks.
Excel styles will make formatting consistent and let you apply and change formatting faster. In this tutorial, you'll learn how to use Excel's built-in styles, how to modify styles, and how to create your own. You'll also learn how to use your custo…

773 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