Sum the cost of the selected ingredients for each burger, to give total cost of burger.

[CatSqueezer]

Hi,

I am re-making this thread because the earlier one ("Is this component included? Ok then add to total cost." - http://www.excelforum.com/excel-form...otal-cost.html) turned out to be too vague.

This time, l have also attached an example spreadsheet for illustration - please see attachment.

As the title of this new thread indicates: I have several burgers on a menu. Each burger uses a different set of ingredients. Each ingredient has a specific cost, listed in the "Ingredient costs" subsection of the spreadsheet.

For each burger: Wherever an ingredient is specified, l want its cost to be cross-referenced from the "Ingredient costs" subsection, and added to the cost of all other ingredients for that burger, and l want the sum placed in the "Total Cost of this burger" column.

Caveat: Whenever Ingredient D has been selected with a "Y", the cost of Ingredient D is only added to Column J if Column F ("Is D available?") also has a "Y"