Summing quantities based on like criteria?

You're welcome!

Biff

"aburnce" <aburnce.25ybf0_1144509301.9067@excelforum-nospam.com> wrote in
message news:aburnce.25ybf0_1144509301.9067@excelforum-nospam.com...
>
> Thank you! That's exactly what I needed.
>
> For anyone who might care...I decided that it would be easier to
> concatenate the Ingredients and Measure columns, then apply the filter
> to that in making my shopping list. This allows my unique list to
> include the same item listed in the various recipes with different
> measures (i.e. 1 recipe calls for 3 tsp of cinnamon, one for 2 tbl).
> Then when I do the SUMIF function, I have my measures visible and can
> more easily identify which ingredients with unlike measures need to be
> converted and added together.
>
> Final version is attached. Thanks, Biff!
>
>
> +-------------------------------------------------------------------+
> |Filename: meal plan spreadsheet.zip |
> |Download: http://www.excelforum.com/attachment.php?postid=4606 |
> +-------------------------------------------------------------------+
>
> --
> aburnce
> ------------------------------------------------------------------------
> aburnce's Profile:
> http://www.excelforum.com/member.php...o&userid=33288
> View this thread: http://www.excelforum.com/showthread...hreadid=531137
>

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

bumpity bump