Summarising daily data by week

[Rainmanne]

I've got daily data, which I want to convert into weekly. However, the data are not for every day. In some cases, it could be from Monday to Sunday, in other it could be only, say, Tuesday and Thursday. Basically any combination. I have a table with a date and a number for that day. I need to single out any week and sum up the numbers for this week to present it as weekly data. Could anyone suggest any method for doing it?

 

[steve the fish]

Sumifs formula or a pivot table.

 

[Rainmanne]

Sumifs formula or a pivot table.

Cannot figure out how to use either in this case. With pivot table I can put date as a row and weekday as a column but I still need to find a way to sum up week by week. With sumifs , again, how I put a condition to sum up only weeks?

 

[steve the fish]

In the pivot just put the dates in the rows and the number in the totals. The weekday doesn't matter. For the sumifs you need to create a table of start date and end date for each week. Then you can go greater or equal to start date and less than or equal to end date.

 

[Rainmanne]

In the pivot just put the dates in the rows and the number in the totals. The weekday doesn't matter. For the sumifs you need to create a table of start date and end date for each week. Then you can go greater or equal to start date and less than or equal to end date.

Thanks a lot. Now I've got it