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! :)


+-------------------------------------------------------------------+
|Filename: meal plan spreadsheet.zip |
|Download: http://www.excelforum.com/attachment.php?postid=4605 |
+-------------------------------------------------------------------+

--
aburnce
------------------------------------------------------------------------
aburnce's Profile: http://www.excelforum.com/member.php...o&userid=33288
View this thread: http://www.excelforum.com/showthread...hreadid=531137