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
Bookmarks