View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Candy Candy is offline
external usenet poster
 
Posts: 18
Default Formula To Sum Up Daily Food Exchanges

I want to sum up how many of each food exchange I have for all my meals in a
day. My table looks something like this:

Breakfast Meat 1
Starch 2
Milk 1
Fat 1
Fruit 1
Vegetable 0

Lunch Meat 2
Starch 2
Milk 0
Fat 1
Fruit 1
Vegetable 1

Dinner Meat 4
Starch 2
Milk 0
Fat 1
Fruit 1
Vegetable 1

How would I write the formula to come up with the total of 7 meats for the
day, for example?

Thanks in advance to whomever may be able to help.