As you can see, I numbered the meals, then put the number needed per meal. This worked out well for me. In Excel, if you don't use letters in the columns you can add up all the stuff, just using the formula for adding. So you have to make sure you keep all amounts the same (i.e. convert everything to Tablespoons or back to teaspoons, whichever works best). Then make a column for totals. This saves so much on second guessing whether you added right.
We had 39 recipes and a side and a sauce and way more ingredients than this. I tried to divide the ingredients between 7 people, but it was not super even. We'll even it up when we figure out who still owes money and who needs to be reimbursed.
|# of recipes||5||5||2||6||6||2|
|aluminum pan (9x13)||5||6|
|aluminum pan (pie)||4|