Hey. Per doctor's orders I am on a very strict diet and have to monitor my calories/cholesterol/sodium etc.

I am trying to use Excel to streamline this process. I have a log sheet where I insert rows (so the newest entry is at the top) and fill them in with what I ate, when, how many calories, etc.

I want to have another sheet which summarizes the totals by either today/week-to-date/month(30 days)-to-date. This would greatly help me always quickly know where I am at, but I am having trouble with figuring out how to sum those 3 things.