Formula To Sum Up Daily Food Exchanges
AWESOME, Mike!!! Thanks!!!
Candy
"Mike H" wrote:
You don't say which columns your adta are in so this assumes Column B for
meat, Starch etc and Column C for the amounts
=SUMIF(B1:B25,"Meat",C1:C25)
Mike
"Candy" wrote:
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.
|