I need to change cells to reflect new costs. Then have these costs roll into new totals.
I attached a worksheet to demonstrate how it works. The numbers in gray should be adjustable. The numbers in tan are summing up incorrectly with my "SUMIF" formula.
Any thoughts to make this work? I should be able to put Current Costs back into New Cost box and get original totals. But I don't.
Thank you much for any help you can give.
Roger!
Last edited by bluerog; 11-18-2009 at 10:53 AM.
the ranges do not appear to be lined up correctly.
try changing the formula from
=SUMIF($A$20:$A$32,B26,$F$19:$F$32) to
=SUMIF($A$20:$A$32,B26,$F$20:$F$32)
Barrfly
Thanks Barrfly. I think that's it. I threw in a "check" for sub component with a vlookup, and a "check" for raw material.
This is what I come up with.
Everything seems to work now when I adjust raw materials.
Roger!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks