how to create shopping list from menu options?

[mchorley]

hi guys,

trying to create an excel sheet where i can tick a meal option, and it will then tell me how many of the required ingredients i need to buy. fairly simple for the educated, and once i have the "base" formula i will hopefully be able to tinker it to my needs ;-)

heres a very basic screenshot of what i want to happen...excel screenshot.jpg

by inserting a "y" in the column next to "fajitas" i would then like the ingredients to all display "1", sure i can tinker if for example i need 2 onions!

Hope you can help

Cheers

Mark

[haru]

try:

=IF(B2="y",SUM(C2:H2),"")

[mchorley]

Welcome to the forum, mchorley.

Please take a few minutes to read the forum rules, and then amend your thread title accordingly.

Thanks.

Thank you SHG, have done so accordingly (hopefully) ;-)

[mchorley]

try:

=IF(B2="y",SUM(C2:H2),"")

Nope.... that just gives me a "0" in the formula box, what im after is a "1" below each of the ingredients, so for example i can build on the sheet, add 20 or so different meals, but pick 7 a week that i want to eat and the sheet will eventually generate a shopping list.

Thx for your reply though, much appreciated :-)

[reddy14]

Add the formula =IF($B2="Y","1","") in cell C2 and drag it down and right(till column-H). See if it helps.

---------------------------------------------------------------------------------------------------------------------------------------------------------
If you are happy with the results, please add to the contributor's reputation by clicking the reputation icon (star icon) below.

Please also mark the thread as Solved once it is solved. Check the FAQ's to see how.

[haru]

Hi mchorley,

I think I know what you are trying to accomplish, I've attached a file with what I think you are looking for. The box to the right will total up all the ingredients you need to buy if there is a "y" in the yes? column. Tell me what you think.

[mchorley]

Hi mchorley,

I think I know what you are trying to accomplish, I've attached a file with what I think you are looking for. The box to the right will total up all the ingredients you need to buy if there is a "y" in the yes? column. Tell me what you think.

MOST EXCELLENT HARU :-))) thats exactly what i was after, i can tinker with evn my limited knowkledge to expand that sheet.... thank you very much.

Mark

[haru]

No problem Mark, I'm glad I was able to help, please remember to edit the title of the post with [Solved].