Table with values from several locations and years

Ricardo Sousa · #1 06-25-2018, 05:47 PM

Dear all,
I need your help to find sales based on the store opening date. See below:

See image 1

I need to find the comparable sales for YTD and MTD based on the opening date:
Since store 123 opened in 2015 – This is easy, the comparable sales in 2018 are from the beginning of the year
Store 124 & 125 opened during 2017 and for that reason the comparable YTD sales should start to sum only after Comp date (COLUMN E).
Is there a formula that I can use to get that?

See image 2

Thanks very much for your help.

Thread Tools
Show Printable Version Email this Page
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Table with values from several locations and years - need to find comp values	Ricardo Sousa	Excel	6	06-09-2018 10:51 PM
code to find account and sum up values	Brian13	Excel Programming	2	05-31-2017 09:26 AM
Find and replace multiple values, according to table value - excel formula	EtanM	Excel Programming	3	04-11-2016 01:43 AM
Display multiple values as new values based on selection from template.	MvdB	Excel	2	09-29-2015 08:51 PM
find 2 values i a table to find the right prise	Vibov	Excel	1	01-11-2015 07:25 AM