Sumif with variable parameter

[batchy]

I have a a table at the top of my worksheet which is a breakdown of performance. (Table 1), i would like Table 2 to roll up performance using a =SUMIFS calculation. However number of rows in table 1 may vary.

[6StringJazzer]

What's Table 1, what's Table 2, where do you need the SUMIFS formula, what are you summing, and what are the criteria?

The short answer is that SUMIFS can be written so you don't care how many rows it looks at. Here is a simple example based on your file that looks at entire columns:

=SUMIFS('Daily(SL)'!AY:AY,'Daily(SL)'!AT:AT,"Scotland",'Daily(SL)'!AU:AU,"Tesco")

[batchy]

What i have decided to do is do the sumifs in a table to the left, and repeated this process.

Seems to work great, many thanks tho