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
INDEX function array causes problem when attempting to use LARGEfunction to sort positive and negati 10
Intelligent VLOOKUP 3
Autofilter using range from another sheet as the criteria 0
synchronizing combo boxes on Infopath 1
Cumulative formula for word table 0
Can you use an INDEX array in a COUNTIF formula ? 1
Referencing text from another cell for criteria in functions 1

Top