Hi all,

I'm looking for a way to write this:

=SUMIF('Sheet1'!$4:$4,'Sheet2'!$D6,'Sheet1'!G306:BG306)
as this:
=SUMIF('Sheet1'!4:4,'Sheet2!$D6,INDEX('Sheet1'!306:306,306,7):INDEX('Sheet1'!306:306,306,200))
Where the criteria runs across a range (G to BG) that can sometimes have columns deleted, but the range must remain fixed.

Cheers