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