I have a table that has sales data per store. The top row has the store number and under that store number is the sales date per day. What I am trying to do is to create a formula that looks up the store name/number in the top row and then calculates the sales in that column if the date in column D is between 2 values (eg. bigger than 2021-11-01 and smaller than 2021-11-15)

Here is a link to the sample data