Week by week automatic sales table calculation

Hi,

I am trying to calculate my sales data by week to week basis.

I have attached a file for better understanding of my problem.
As you can see in the "Sheet1" I have created a table that is separated on weekly basis.
And I want the sales number shown from the other sheet "SalesData".
For the first two weeks I just SUMed the sales number together each time.
Which would take a long time to do for the entire Year.
But I want to make it automated that If I create a table(just like the February daily sales table) it calculates by it self.

I can easily create a table that shows the daily sales for example the FEBRUARY daily sales.
But how do I add them up into a weekly sales?

Could somebody please help me?

Thank you.

Put this formula in I8:

=SUMIFS(SalesData!E:E,SalesData!$A:$A,">="&$G8,SalesData!$A:$A,"<"&$G8+7)

Copy across into J8:K8, then copy those 3 formulae down as far as you need them.

Hope this helps.

Pete

Thank you Pete for the fast and excellent answer.