Hello,
I have a problem that I am trying to figure out in excel. I have a sales report and the summary tab is on "sheet 1".. The first table in blue allows you to pick a week and have the table auto calculate sales from that week based on the segment and brand.
However, on the red table I would like to do the same thing but allow you to put in 2 dates so that it can calculate the sales between (and including) the 2 dates given. So for example, if for "Last Year" you choose 3/7/2015 and 3/28/2015 the cells would auto-calculate and give you the sum of sales for all those dates.
Because of the amount of information (only a snippet in the attachment) there is a UNITS and DOLLARS tab where the data is stored.
The way the sheet works is 2015 includes 2/7/15 - 1/30/16 and 2016 includes 2/6/16 - 1/28/17. There is not a lot of data for 2016 so it might be easier to make the formula for 2015 and then I can copy over. Thanks so much.
Bookmarks