refer to a cell using a formula?

[me]

Hi, I want to refer to the contents of a cell with a variable representing
the column, but I can't figure out how to make Excel do this in A1
(preferred) or R1C1 format - sort of the reverse of the ADDRESS function.
More specifically, I want to sum the values for months of a year where the
month is the variable. What's the syntax?

A B C D
1 J F M A
2 2 3 2 4
3 2/1/05
4 =sum(text("A1:"&month(A3),))

other ideas that I can't seem to make work:
char(month(a3)+64)
column(a3)

Thanks,
Mike

 

[JE McGimpsey]

If I understand you correctly, one way:

=SUM(OFFSET(A2,0,0,1,MONTH(A3))