Formula To Sum Up Daily Food Exchanges

C

Candy

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.
 
M

Mike H

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
 
C

Candy

AWESOME, Mike!!! Thanks!!!

Candy

Mike H said:
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
Click to expand...
 
C

Cimjet

Hi Candy
If all in the same column, name with quantity maybe =COUNTIF(A1:A20,"Milk
0") for example, try it.
Regards
Cimjet
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Need an expression that's larger than my skill 5
How delete rows from DataTable and avoid "no row at position" error? 3
INDEX function array causes problem when attempting to use LARGEfunction to sort positive and negati 10
Are you wasting food? 18
All Hallows' Evening 20
Can you use an INDEX array in a COUNTIF formula ? 1
How to group multiple items in to three groups. 4
Working out a value within a certain month. 14

Top