Not sure where to look for this.
I have a spreadsheet containing recipes and the ingredients used for them. I want to sort by ingredients (peanuts might come up in 3 recipes, for instance, and each has a quantity listed in a corresponding cell), then sum the total quantity of that ingredient needed across all recipes that contain it. Not sure if this is done with a formula, a pivot table, or something else. Any help would be appreciated.
If this is not clear, my end result would be that I have an easy Excel way to just list the quantities of all the ingredients needed for a bunch of recipes, then go shop for the total quantity of each ingredient that I need. I'm a backpacker trying to put together a meal plan for a week-long trip.
See the attached sheet - I'm trying to work with the Ingredients and Total Qty columns.
THANKS!
Bookmarks