Need to Track Calories, Need to Sum by Time Periods

[Bob McCusker]

Unfortunately I was put on a strict diet and have to reduce my calories. Long story short I am inputting them in an Excel file (Sheet 1). I have another sheet (Sheet 2) where I would like to be able to view the amount of calories consumed by time period, such as 24 hours, week, month, etc. I was wondering if anyone could help me come up with a template formula I could use to just switch the time on.

I don't know if this is pertinent but I log the entries with the top being the most recent. I know inserting rows like this can be an issue. Thanks.

 

[Shope]

Hi Bob,

Could you please attach the worksheet so that I may take a look at it?

Thanks,

Michael Shope

 

[Excelestial]

It appears that you are asking for a tracker to be put together for you. If so, I'll be happy to do that for you if you want to inbox me your email address. I also need to know what version of Excel you're using.

 

[Bob McCusker]

Here is an example, 2 sheets below:

<table border="1" cellpadding="0" cellspacing="0"><tbody><tr style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt; FONT-WEIGHT: bold"> <td>
</td> <td>A</td> <td>B</td></tr> <tr style="HEIGHT: 18px"> <td style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">1</td> <td style="FONT-WEIGHT: bold">TIME</td> <td style="TEXT-ALIGN: left; FONT-WEIGHT: bold">CAL</td></tr> <tr style="HEIGHT: 18px"> <td style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">2</td> <td>24 hour</td> <td>
</td></tr> <tr style="HEIGHT: 18px"> <td style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">3</td> <td>3 day</td> <td>
</td></tr> <tr style="HEIGHT: 18px"> <td style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">4</td> <td>week</td> <td>
</td></tr> <tr style="HEIGHT: 18px"> <td style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">5</td> <td>month</td> <td>
</td></tr> <tr style="HEIGHT: 18px"> <td style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">6</td> <td>total</td> <td style="TEXT-ALIGN: right">910</td></tr></tbody></table>
<table border="1" cellpadding="0" cellspacing="0"><tbody><tr style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt; FONT-WEIGHT: bold"> <td>
</td> <td>A</td> <td>B</td> <td>C</td> <td>D</td> <td>E</td> <td>F</td></tr> <tr style="HEIGHT: 18px"> <td style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">1</td> <td style="FONT-WEIGHT: bold">ENTRY</td> <td style="FONT-WEIGHT: bold">DATE</td> <td style="FONT-WEIGHT: bold">TIME</td> <td style="FONT-WEIGHT: bold">MEAL</td> <td style="FONT-WEIGHT: bold">ITEM</td> <td style="FONT-WEIGHT: bold">CALORIES</td></tr> <tr style="HEIGHT: 18px"> <td style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">2</td> <td style="TEXT-ALIGN: left; BACKGROUND-COLOR: #ccccff">00003</td> <td style="TEXT-ALIGN: left; BACKGROUND-COLOR: #ccccff">09/03/11</td> <td style="TEXT-ALIGN: left; BACKGROUND-COLOR: #ccccff">05:00 PM</td> <td style="TEXT-ALIGN: left; BACKGROUND-COLOR: #ccccff">lunch</td> <td style="TEXT-ALIGN: left; BACKGROUND-COLOR: #ccccff">salad</td> <td style="TEXT-ALIGN: left; BACKGROUND-COLOR: #ccccff">320</td></tr> <tr style="HEIGHT: 18px"> <td style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">3</td> <td style="TEXT-ALIGN: left; BACKGROUND-COLOR: #ccccff">00002</td> <td style="TEXT-ALIGN: left; BACKGROUND-COLOR: #ccccff">09/03/11</td> <td style="TEXT-ALIGN: left; BACKGROUND-COLOR: #ccccff">04:00 PM</td> <td style="TEXT-ALIGN: left; BACKGROUND-COLOR: #ccccff">snack</td> <td style="TEXT-ALIGN: left; BACKGROUND-COLOR: #ccccff">bagel
</td> <td style="TEXT-ALIGN: left; BACKGROUND-COLOR: #ccccff">145</td></tr> <tr style="HEIGHT: 18px"> <td style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">4</td> <td style="TEXT-ALIGN: left; BACKGROUND-COLOR: #ccccff">00001</td> <td style="TEXT-ALIGN: left; BACKGROUND-COLOR: #ccccff">09/03/11</td> <td style="TEXT-ALIGN: left; BACKGROUND-COLOR: #ccccff">09:00 AM</td> <td style="TEXT-ALIGN: left; BACKGROUND-COLOR: #ccccff">breakfast</td> <td style="TEXT-ALIGN: left; BACKGROUND-COLOR: #ccccff">pb&j</td> <td style="TEXT-ALIGN: left; BACKGROUND-COLOR: #ccccff">445</td></tr></tbody></table>

 

[Bob McCusker]

Is there a way I could do this without a tracker? A formula that just looks up the dates and sums the numbers would be fine if a tracker is too much effort.

 

[scottylad2]

Is there a way I could do this without a tracker? A formula that just looks up the dates and sums the numbers would be fine if a tracker is too much effort.

What are you planning on, enter daily calories under each date or are you wanting it to be meal by meal or something to include snacks? You can also have it colour red or whatever if you exceed your daily max, or not if you choose just to have a constnnt daily input

sample below

Excel Workbook
	B	C	D	E	F	G	H	I	J	K	L	M	N	O
4	01/01/2011	02/01/2011	03/01/2011	04/01/2011	05/01/2011	06/01/2011	07/01/2011	08/01/2011	09/01/2011	10/01/2011	11/01/2011	12/01/2011	13/01/2011	14/01/2011
5	1237	1913	2094	1543	1461	2470	1067	1778	1392	2406	773	2218
6	Start & End dates
7	01/01/2011	08/01/2011
8	13563
9
10	Month to Date
11	20352
Sheet3