Excel data retrieval for pizzeria

Ok - tried it again, took out spaces in the file name. Hopefully that works!

I just love pizza lol

Is this what your looking for ?? Must of it is done, but I've notice not all product on the data cost sheet.

If you wish to add just look what I did with the other products. In row 3 adjust the formula then drag the box down to copy the formula down the sheet.

Then on the Pizzas sheet make sure the new produce are in the sum formula.
In the food cost column.

PM if more information is needed.

ratcat: PERFECT! That is exactly what I wanted - thank you SO MUCH. I realize I hadn't quite finished adding in all the topping costs as this is a work in progress, but it definitely looks like that's the ticket. I was looking at the Food Cost and saw how expensive those pizzas were, and I was like..what the !@#$ - then I realized the sauce pricing in my data chart was way out of whack and causing the high numbers.

Regardless, this will be perfect once I get my numbers put in. You are a life saver!

Thanks again

Sean