I'd like to take this spreadsheet one step further and add the ability to select which recipes I want to shop for. I would just build recipes into the spreadsheet, then have an INCLUDE column with Y/N values indicating whether to include a particular recipe for a given trip. I would then somehow apply the Advanced Filter only to the items with Y selected, and would SUMIF only the quantities where Y is selected. So I guess there are two things here I need to know how to do:

1.) Apply the Advanced Filter based only on items in a list that meet a criteria, rather than the whole list

2.) Create a SUMIF statement that uses TWO criteria: one for whether the ingredient name matches, and one for whether Y is selected in the INCLUDE column.

Thanks in advance for the help.

Alan