Solved

Have a toughy formula request

Posted on 2014-01-29
2
335 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:Pete Edwards
[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
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:Pete Edwards
ID: 39818370
that got the job done, thx
0

Featured Post

Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

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

Outlook Free & Paid Tools
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…
This Micro Tutorial demonstrates in Microsoft Excel how to consolidate your marketing data by creating an interactive charts using form controls. This creates cool drop-downs for viewers of your chart to choose from.
Although Jacob Bernoulli (1654-1705) has been credited as the creator of "Binomial Distribution Table", Gottfried Leibniz (1646-1716) did his dissertation on the subject in 1666; Leibniz you may recall is the co-inventor of "Calculus" and beat Isaac…

738 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