Calculate items sold within 10 days prior to specified date

[joeltes]

Hi all,

I have a list of sale line items, one column has a date, the other the number of items sold. How can I sum number of items sold, where order date is <2/12/18 and >2/02/18 but instead of inputting the date, I would select a cell containing 2/12/18 (i.e E3) and tell the formula to look for 10 days prior to E3?

 

[Marcílio_Lobão]

joeltes, Good afternoon.

Suppose:
A1 --> Date to be checked
E3 --> 02/12/2018

Try to use:

...AND(A1>E3-10, A1<E3)...

Is that what you want?

I hope it helps.

 

[jtakw]

Hi,

You said <2/12/18 and >2/02/18, that's Only 9 days, the following formula assumes you want 10 days Prior to date in E3 (2/12/18), so from 2/2/18 to 2/11/18 inclusive:

Book1
	A	B	C	D	E
1	Date	Items Sold	Total Sold 10 days Prior to E3
2	2/1/2018	20	590
3	2/2/2018	30			2/12/2018
4	2/3/2018	40
5	1/15/2018	50
6	2/5/2018	60
7	2/6/2018	70
8	2/7/2018	80
9	2/8/2018	90
10	2/9/2018	100
11	2/20/2018	110
12	2/11/2018	120
13	3/14/2018	130
Sheet25

Cell Formulas
Range	Formula
C2	=SUMIFS(B2:B13,A2:A13,">="&E3-10,A2:A13,"<"&E3)

 

[joeltes]

This worked perfectly. thanks for your response and knowledge.

 

[jtakw]

You're welcome, welcome to the forum.