calculating macronutrients

[dccd01]

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

	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>

 

[Eric W]

Something like this?

	A	B	C	D	E	F	G	H	I	J
1								7/15/2018	7/16/2018
2		Calories	Fats	Carbs	Protein			servings	servings
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	833	987
18							Fats	26	57.2
19							Carbs	1	8
20							Protein	145.7	101.6

<tbody>
</tbody>

Sheet4

Worksheet Formulas Cell Formula H17 =SUMPRODUCT(INDEX($B$4:$E$14,0,MATCH($G17,$B$2:$E$2,0)),H$4:H$14) <tbody> </tbody>

<tbody>
</tbody>