Hi, I've been doing some detailed diet planning and have put together a spreadsheet to calculate various micro/macro nutrients and have attached it.
So far i have a sheet containing data on the contents of various ingredients and am constructing a sheet allowing you to create meals from the ingredients which will then give you a total for the meal in the row at the bottom of your list of ingredients.
In the sheet "Meals" I have it setup to lookup the data from the ingredients tab and fill in based on the drop down on the left.
The aim is that if you select total from the dropdown in column E of meals it will then total everything in the rows above up too and including the row including the name of the meal. For example the "tomato egg chorizo" meal once you select total underneath the egg ingredient would automatically calculate the total for all nutrients in the meal in the same row as the total in B5.
I was thinking I'd be able to change the True portion of the if statement in E5 allowing me to copy it to the rest of the sheet but i can't work out how to get match or countblank too work in this manner.
I hope it is clear what I am trying to achieve,
Thankyou!
Bookmarks