Originally Posted by
Tommy1005
I added a column in the Input tab in column Z which finds the savings from the old bid and the new bid. So maybe the formula can just Sum that column and multiply it by the EAQ and it only sums it for Supplier 1 when the Location, Sub Category, Category, and part number match.
That is 100% the right thing to do - you can use the same formula you used for Col Z to generate the EAQ Savings in Col AA by simply changing the SUM range from Col Q (Del. Price) to Col N (EAQ)
Then modify H6 on Summary to use Col AA as sum rather than Col Z as is presently the case.
Originally Posted by
Tommy1005
For cell H7 I'm just trying to get the price in the Decode tab which is under Q6. and multiply it by the EAQ. so .76 * 72300 and again the supplier needs to match what part numbers they bid on based on the Input sheet and match the category, sub-category and location.
You could create another SUMIFS on Decode to hold this value, however, given you have the Savings & EAQ values already you could equally use:
Then for H7 use the same as H6 but modify summation range from AA to AB.
Bookmarks