Forum Discussion
Ingredients calculator
Hi Lewis, I appreciate the spreadsheet! I have a question is there a way to enter multiple recipes to get the total amount of each ingredients to know much ingredients total for those recipes to order/purchase. Example: Cookies- 2 cups of chocolate chips, 1 cup of butter, Truffles-3 cups of chocolate chips, 1/2 cup of butter. For this order I need to purchase 5 cups of chocolate chips and 1 1/2 cups of butter. I would really appreciate the help instead of manually added up the total amount of ingredients to purchase each time I get a different orders.
(This is Snowman55, not Lewis.)
If you are using Excel 365 or Excel for the web, the workbook attached to this reply has one solution, and additional information for you on the _Info worksheet.
SnowMan55,
I saw the error in the formula, but now I'm getting a error for "Too many ingredients! Update this worksheet." Do you have any suggestion where I can add all my ingredients? I have a lot more recipes to enter.
See my response via private message.
SnowMan55,
What did I do? All I did was updating my ingredients.
Thanks SnowMan55, I really appreciate it!! Once again my apologies for addressing you wrong.
Hi Snowman55,
My apologies for calling you by the wrong name. I realized after I posted and couldn’t figure out how to edit my post. Thanks for the spreadsheet! I’ll check it out later tonight.