Solved

Have a toughy formula request

Posted on 2014-01-29
2
324 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
Comment Utility
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
Comment Utility
that got the job done, thx
0

Featured Post

Get up to 2TB FREE CLOUD per backup license!

An exclusive Black Friday offer just for Expert Exchange audience! Buy any of our top-rated backup solutions & get up to 2TB free cloud per system! Perform local & cloud backup in the same step, and restore instantly—anytime, anywhere. Grab this deal now before it disappears!

Join & Write a Comment

Suggested Solutions

Using Word 2013, I was experiencing some incredible lag when typing.  Here's what worked for me....
This code takes an Excel list of URL’s and adds a header titled “URL List”. It then searches through all URL’s in column “A”, looking for duplicates. When a duplicate is found, it is moved to the top of the list. The duplicate URL’s are then highlig…
The viewer will learn how to create two correlated normally distributed random variables in Excel, use a normal distribution to simulate the return on different levels of investment in each of the two funds over a period of ten years, and, create a …
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…

762 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

9 Experts available now in Live!

Get 1:1 Help Now