Dynamic Sum Based on Date (Sales Next X# Days Out)

**eNinjaInTraining** · 04-10-2020, 10:16 AM

I have dates in col. 1 and projected sales in col. 2. I'm trying to create a dynamic formula that adds the next 7 days of projected sales together based on the current date/value for "Today". Can you please advise? Not sure of easiest way to do this.

**XOR LX** · 04-10-2020, 10:21 AM

Hi,

=SUM(SUMIF(A:A,E2+{0,1,2,3,4,5,6},B:B))

Regards

**Bo_Ry** · 04-10-2020, 12:25 PM

Please try
=SUMIFS(B:B,A:A,">="&E2,A:A,"<="&E2+6)

**XOR LX** · 04-10-2020, 12:42 PM

Bo_Ry's solution should be about 7 times faster than mine!

(I was just wanting to demonstrate a potential use of array constants to everyone.

)

**eNinjaInTraining** · 04-10-2020, 01:31 PM

Thanks a lot, Bo_Ry and XOR LX!!

Dynamic Sum Based on Date (Sales Next X# Days Out)

LinkBack

Thread Tools

Rate This Thread

Display

Dynamic Sum Based on Date (Sales Next X# Days Out)

Re: Dynamic Sum Based on Date (Sales Next X# Days Out)

Re: Dynamic Sum Based on Date (Sales Next X# Days Out)

Re: Dynamic Sum Based on Date (Sales Next X# Days Out)

Re: Dynamic Sum Based on Date (Sales Next X# Days Out)

Thread Information

Users Browsing this Thread

Similar Threads

VBA to create a dynamic array which sums sales to a specific client based on product

Need help determining prorated days off based on 90 days after hire date

Trying to create a dynamic report that pulls sales data from another tab based on week

[SOLVED] Calculate number of days between sales and prior sales date

[SOLVED] sales projection for a month based on several days of data

Finding the Average for first 20 days of Sales based on "On Sale" date and range

Creating a Dynamic Inventory List Based on Daily Sales

Tags for this Thread

Bookmarks

Bookmarks

Posting Permissions