how do i get excel to display the result of a formula i build?

[Mike]

Cell A1 is jan, B1 is feb, C1 is mar, etc
row 2 has values for each month
cell C1 has a date 2/3/05
I want to sum the values for jan through X where X is month(C1)
I built a text string I want Excel to evaluate as a formula. What's the
function to do that?

For instance, C2 might be ="="&char(64+month(C1))&2
I want this to resolve the formula =B2, not display "=B2"

Any ideas?
Thanks,
Mike

 

[daddylonglegs]

Hi Mike

To answer your specific query - use INDIRECT

=INDIRECT(CHAR(64+MONTH(C1))&"2")

but if your aim is to sum row 2 from A2 to another cell based on a
specific month then there's probably an easier way to do that based on
INDEX/MATCH type formula.

Are your entries in row 1 text? If so and based on a date in A3

=SUM(A2:INDEX(A2:L2,MATCH(TEXT(A3,"mmm"),A1:L1,0)))

 

[Mike]

Thank you DLL, I think either will work.
-Mike
"daddylonglegs" <[email protected]>
wrote in message
news:[email protected]...