Hi!

First thing you need to do is to convert the TEXT numbers in column D to
NUMERIC numbers.

Select cell A1
Goto EditCopy
Select the range D4:D91
Goto EditPaste SpecialAddOK

Now, create a list of the unique ingredients.

Select the range C3:C91
Goto DataFilterAdvanced Filter
Select Copy to another location
Copy to: $M$3
Select Unique records only
OK

Now, get the total needed.

Enter this formula in N4:

=SUMIF(C$4:C$91,M4,D$4:D$91)

Copy down to N56.

Biff

"aburnce" wrote in
message ...

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