Hello,
I entered in a workbook 5 sheets containing 5 different
recipes in each sheet. each sheet contained, in column a; volume of
ingredient,
column b name/description of ingredient. in the last sheet (6) I listed, in
column a, all ingredients used in all recipes (sheets), and in column b I
want to have a formula which will return how much (sum) of that
ingredient I will need based on a table in sheet 6 where I can select
(via drop down list) which and/or how many recipes (sheets) I am selecting.

Thanks in advance,

Jay