Results 1 to 6 of 6

Summing quantities based on like criteria?

Threaded View

  1. #1
    Registered User
    Join Date
    04-07-2006
    Posts
    7

    Question Summing quantities based on like criteria?

    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!
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1