Sum, based on changing value in a cell

[Mark F]

I have a cell, lets say A1, that has a letter that changes based on a day...

Monday is column G, so sum of Sunday and Monday last year is
=SUM('LAST YEAR'!F7:G7) - I have a few rows that will need to be summed

What I want to be able to do is change the letter in A1, and sum the columns

Something like =SUM('LAST YEAR'!F7:&A1&ROW(A7))

I know it's a very simple one, but I just can't get it right

Thanks for any help
Mark

 

[Aladin Akyurek]

Like this:

=SUM(OFFSET('LAST YEAR'!F7,0,0,1,A1))

where A1 indicates how many columns to sum from F7 on.

 

[JustynaMK]

Hi Mark,
How about:
=SUM(F7:INDIRECT(A1&7))