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.

Formula To Sum Up Daily Food Exchanges
 

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.

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.

Formula To Sum Up Daily Food Exchanges
 

Hi Candy
If all in the same column, name with quantity maybe =COUNTIF(A1:A20,"Milk
0") for example, try it.
Regards
Cimjet
"Candy" wrote in message
...
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.

Formula To Sum Up Daily Food Exchanges
 

Glad to be of help

"Candy" wrote:

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.