| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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. |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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. |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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. |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| I need a template to figure out weekly food costs... | Excel Discussion (Misc queries) | |||
| New Food Pyramid | Charts and Charting in Excel | |||
| how do i set up inventory for food? | Excel Worksheet Functions | |||
| Linking Daily Worksheet To Daily Invoice Total | Excel Worksheet Functions | |||
| Food Details. | New Users to Excel | |||
Linear Mode
