Hi,
I have a workbook with one tab per project. These tabs contain tables where people can insert information and one summary table (Table2) at the end (which moves downwards as the table above it is populated).
I need a summary-summary table, that will take certain information from Table2 in each sheet and sum it depending on criteria.
I've partially managed the solution by using SUMPRODUCT(SUMIF(INDIRECT as you can see in the image below.

Question_Forum.PNG

The issue is that the sum range I8:I28 needs to be dynamic, as the tables in each project sheet will go downward and there fore the starting cell for the sum range is not always I18.
I can't just use all column I as there is other info in the table above it that would be summed but shouldn't.
I want a way to find the starting cell for "Total", "Jan", "Feb" etc in each project sheet that takes into account that won't be the same cell in each sheet.

Any ideas?
Thanks!