Totalling Days and Weeks of data...

[1957GoldTop]

I have a spreadsheet with data like this:
Date Meal Calories
1/11/16 Breakfast 260
1/11/16 Lunch 270
1/11/16 Dinner 406.3
1/11/16 Snacks 1320
1/12/16 Breakfast 270
1/12/16 Lunch 330
1/12/16 Dinner 421.2
1/12/16 Snacks 1500
(and on)

I would like create a table that shows (i.e. totaling up each day):
Date TotalCalories
1/11/16 2,256.3
1/12/16 2,521.2
(and on)

Then, I would like another total that can take the daily totals and total them by week, so I would get something like:
Week Beginning Total Calories
1/8/16 15,152.5
1/15/16 15,264.1
1/22/16 14,654.2
(and on)

Any help on how I can do this would be appreciated!

Thanks!

[chrisbeaudet]

The SUMIF function is going to be what you want to use for the first part of it. After that, for the weekly, you can just us the SUM function to bring add all the values from the daily counts.