Summing quantities based on like criteria?

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!

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