I just started a food diary and am wanting Excel to calculate my calories and macro nutrients automatically. Not sure how to do this, but would like for it to multiply the number of servings I had by the calories, Fats, Carb, and Proteins each day, and add them up for the day's total. Add all the calories I consumed, all the fats, etc. Basically, a formula that will populate cell H17 with that day's calories, H18 with the fats, etc. Thanks
<tbody>
</tbody>
A | B | C | D | E | F | G | H | I | |
7/15/2018 | 7/16/2018 | ||||||||
1 | Calories | Fats | Carbs | Protein | servings | servings | |||
2 | |||||||||
3 | |||||||||
4 | Prepared fruit/veg | ||||||||
5 | cauliflower - riced | 3/4 c | 25 | 0 | 1 | 2 | 1 | ||
6 | cauliflower - mashed | 1/2 c | 60 | 1 | 8 | 2 | 1 | ||
7 | |||||||||
8 | Meats | ||||||||
9 | Rotisserie Chicken - w/skin | 6 oz | 630 | 28 | 0 | 94.3 | |||
10 | Rotisserie Chicken - no skin | 6 oz | 508 | 12 | 0 | 99.7 | 1 | ||
11 | Salmon - baked | 6 oz | 300 | 14 | 0 | 44 | 1 | 1 | |
12 | Crabmeat - white can | 2 oz (half can) | 30 | 0 | 1 | 7 | |||
13 | Ham - baked | 4oz slice | 201 | 10.2 | 0 | 25.6 | 1 | ||
14 | corned beef - | 3.5 oz | 213 | 16 | 0 | 15 | 2 | ||
15 | |||||||||
16 | |||||||||
17 | Calories | ||||||||
18 | Fat | ||||||||
19 | Carbs | ||||||||
20 | Protein |
<tbody>
</tbody>