I've attached a simple version of the worksheet I'm having issues with.

There are 5 tables shown with dates, product code, cost. I'm using SUMPRODUCT formula in cells C7:E7 to gather SEP-13 sales from each of these tables. When I drag the three formulas to the right, the new formulas for the last two tables are incorrect.

My actual spreadsheet has 72 tables, so I want to be able to drag the formula to capture all of these tables. The format of all the tables is the same.

Thank you for helping!



EXCEL WORKSHEET NOV-14.xlsx