+ Reply to Thread
Results 1 to 7 of 7

Quanity calulator for grocery list

  1. #1
    Registered User
    Join Date
    04-10-2019
    Location
    VA
    MS-Off Ver
    Excel 2010
    Posts
    23

    Quanity calulator for grocery list

    I'm trying to make a calculator to automatically add up all the ingredients I need for my grocery list. I have a list created that removes all the duplicate ingredients, but when I try to add the quantity it doesn't match up with the ingredient.
    Ideally, I'd like the list to
    1) is populated by only the ingredients I need. ( I know there is a way to do this, I just can't wrap my head around the coding)
    2) adds up the quantities of those ingredients listed.

    I'm also NOT trying to do this in VBA.

    Please see attached excel for specifics
    Attached Files Attached Files

  2. #2
    Forum Contributor jomaor1's Avatar
    Join Date
    10-08-2018
    Location
    Brasil
    MS-Off Ver
    Excel 2016
    Posts
    177

    Re: Quanity calulator for grocery list

    Hello,

    Try this formula in J2:

    Formula: copy to clipboard
    Please Login or Register  to view this content.


    And copy it down.

    Cheers!
    John.

    "I excel at jumping to conclusions"

  3. #3
    Forum Expert
    Join Date
    09-25-2015
    Location
    Milan Italy
    MS-Off Ver
    office 365
    Posts
    1,781

    Re: Quanity calulator for grocery list

    H2=IF(H$1<>"",IFERROR(INDEX(B$2:B$32,SMALL(IF($A$2:$A$32=$F$2,ROW(B$2:B$32)-ROW(B$2)+1),ROWS($B$2:B2))),""),"")

    control+shift+enter

    copy across and down
    Attached Files Attached Files

  4. #4
    Registered User
    Join Date
    04-10-2019
    Location
    VA
    MS-Off Ver
    Excel 2010
    Posts
    23

    Re: Quanity calulator for grocery list

    Thank jomaor1 that worked perfectly. Thank you!!!
    Last edited by rose8693; 11-14-2019 at 11:57 AM.

  5. #5
    Registered User
    Join Date
    04-10-2019
    Location
    VA
    MS-Off Ver
    Excel 2010
    Posts
    23

    Re: Quanity calulator for grocery list

    CARACALLA, I appreciate what you did with the code, but I need it to pull from more than 1 recipe. that was whole idea behind this that it would add up the total amount of a ingredient needed to multiple recipes.

  6. #6
    Forum Expert
    Join Date
    12-11-2011
    Location
    Netherlands
    MS-Off Ver
    office 365
    Posts
    3,292

    Re: Quanity calulator for grocery list

    Try a pivot table.
    Attached Files Attached Files
    Willem
    English is not my native language sorry for errors
    Please correct me if I'm completely wrong

  7. #7
    Registered User
    Join Date
    11-11-2019
    Location
    London
    MS-Off Ver
    microsoft pc
    Posts
    6

    Re: Quanity calulator for grocery list

    H2=if(h$1<>"",iferror(index(b$2:b$32,small(if($a$2:$a$32=$f$2,row(b$2:b$32)-row(b$2)+1),rows($b$2:b2))),""),"")

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Complete Newbie Here, Grocery List Help
    By CassieBurt in forum Excel Charting & Pivots
    Replies: 10
    Last Post: 09-21-2016, 11:59 AM
  2. Grocery list
    By jammerculture in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 08-19-2015, 04:22 PM
  3. [SOLVED] Creating a grocery list in a new worksheet based on selected items in a master list
    By jacolli4 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 07-28-2012, 07:53 AM
  4. List range of products only if quanity is greater than 1 (on another sheet)
    By bluemarketing in forum Excel - New Users/Basics
    Replies: 6
    Last Post: 05-06-2012, 08:41 PM
  5. [SOLVED] Grocery List with Price comparison
    By mrJack808 in forum Excel General
    Replies: 8
    Last Post: 04-04-2012, 10:57 AM
  6. First Time Poster - Questions about Grocery List
    By Pastor in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 10-20-2006, 03:38 PM
  7. a weekly grocery list and costs, available coupons and value
    By Excellente12 in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 07-24-2006, 12:20 AM

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