Heya guys and gals!
First off I'd like to explain what I want my excel sheet for.
I'm right now trying to shred the last bits of fat for the summer and thought I'd try a Keto diet, this depends heavily on not eating very many carbs, as well as keeping your total Kcal intake below maintenance.
This makes for a fairly tricky diet, as most things you generally eat contains alot of carbs, so I thought I'd make planning my meals easy, by creating an excel sheet, with drop down menues for different foods/drinks as well as their nutritional content.
I''d like it to look something like this, with the dropdown list under "Food"
,,,,,,,,,,,,,,,,,,,,,,,,,,Food Carbs Protein Fat Energy (Kcal)
Breakfast
Breakfast#2
Drink
Total:
-----------------------------------------------------------------
Lunch
Lunch2
Drink
Total:
------------------------------------------------------------------
Dinner
Dinner2
Drink
Total:
------------------------------------------------------------------
Evening meal1
Evening meal2
Drink
Total:
-----------------------------------------------------------------------
All day total:
I hope you get the idea
Now, I managed to create a drop down list of foods, and managed to get it tho show all the content I'm interested in, but I cant add the totals.
If i pick, 2 foods and a drink from my drop down list it changes the row that is shown, not the value in a specific row/column if you get what I'm trying to say, so I cant use a: =SUM(F1:F3:F5) thingie, cause that just adds the value in those rows in my list, not what i pick in the drop down.
I dont know if I'm making any sense, but I hope I can get some help here. I'm a complete novice when it comes to stuff like this and I've been sitting here all day long without making any progress whatsoever.
Best regards
/Johan
First off I'd like to explain what I want my excel sheet for.
I'm right now trying to shred the last bits of fat for the summer and thought I'd try a Keto diet, this depends heavily on not eating very many carbs, as well as keeping your total Kcal intake below maintenance.
This makes for a fairly tricky diet, as most things you generally eat contains alot of carbs, so I thought I'd make planning my meals easy, by creating an excel sheet, with drop down menues for different foods/drinks as well as their nutritional content.
I''d like it to look something like this, with the dropdown list under "Food"
,,,,,,,,,,,,,,,,,,,,,,,,,,Food Carbs Protein Fat Energy (Kcal)
Breakfast
Breakfast#2
Drink
Total:
-----------------------------------------------------------------
Lunch
Lunch2
Drink
Total:
------------------------------------------------------------------
Dinner
Dinner2
Drink
Total:
------------------------------------------------------------------
Evening meal1
Evening meal2
Drink
Total:
-----------------------------------------------------------------------
All day total:
I hope you get the idea
Now, I managed to create a drop down list of foods, and managed to get it tho show all the content I'm interested in, but I cant add the totals.
If i pick, 2 foods and a drink from my drop down list it changes the row that is shown, not the value in a specific row/column if you get what I'm trying to say, so I cant use a: =SUM(F1:F3:F5) thingie, cause that just adds the value in those rows in my list, not what i pick in the drop down.
I dont know if I'm making any sense, but I hope I can get some help here. I'm a complete novice when it comes to stuff like this and I've been sitting here all day long without making any progress whatsoever.
Best regards
/Johan