# Have a toughy formula request

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
###### Who is Participating?

Commented:
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 Commented:
that got the job done, thx
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.