Date Range - Calculating 7 and 28 days sales

[VixPea]

I really don't know where to start here so I'm hoping one of you clever folk out there will know the answer!!

I've got a spreadsheet (ironically enough!) with a list of part numbers in Column A.. Column B & C are headed Sales 7 & Sales 28.

There is another tab in the workbook which is total sales to date - what I'd like to do is referencing Column A products against how many were sold in a 7 and 28 day period from the current days date.

Currently I'm having to pull three reports (Weekly/Monthly/To Date) sales and then use a lookup to work out how many off each tab. It's time consuming and the data is already there in the To Date tab, I just don't know how to go about getting it out!!

Thanks so much in advance!!

 

[VixPea]

Anyone

 

[FormR]

Hi, something like this maybe?

Excel 2013
	A	B	C
1	Product	Sales 7	Sales 28
2	A	23	71
3	B	135	177
4	C	51	51
5	D	0	0
Sheet1

Cell Formulas
Range	Formula
B2	=SUMIFS(Sheet2!$C:$C,Sheet2!$A:$A,$A2,Sheet2!$B:$B,">=" & TODAY()-7)
C2	=SUMIFS(Sheet2!$C:$C,Sheet2!$A:$A,$A2,Sheet2!$B:$B,">=" & TODAY()-28)

Excel 2013
	A	B	C
1	Product	Date	Sales
2	C	10/03/2016	38
3	A	26/05/2016	23
4	B	13/03/2016	13
5	A	10/03/2016	49
6	B	03/03/2016	3
7	B	06/05/2016	44
8	A	19/03/2016	48
9	B	21/05/2016	37
10	C	04/05/2016	16
11	C	15/05/2016	35
12	A	26/02/2016	13
13	B	28/02/2016	16
14	B	04/04/2016	42
15	B	22/04/2016	34
16	B	10/05/2016	20
Sheet2

 

[VixPea]

Thank you SO much.. now I see what you did it looks obvious, but while I can hold my own in Excel with basic stuff once its get a bit complicated I lose all faith in my ability!!! Much appreciated