Solved

Have a toughy formula request

Posted on 2014-01-29
2
332 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

Salesforce Made Easy to Use

On-screen guidance at the moment of need enables you & your employees to focus on the core, you can now boost your adoption rates swiftly and simply with one easy tool.

Question has a verified solution.

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

Suggested Solutions

Some code to ensure data integrity when using macros within Excel. Also included code that helps secure your data within an Excel workbook.
When you see single cell contains number and text, and you have to get any date out of it seems like cracking our heads.
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 demonstrate the bugs in Microsoft Excel for Mac with Pivot Charts.

821 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