Having your formula would help. The INDIRECT function will accomplish what
you want. But without your formula, I cannot tell what is wrong.

Tyro

"SmilingSteve" wrote in message
...
I have an excel workbook with multiple work sheets (Summary, January,
february..., December) On the Summary worksheet I want to create a 3d
reference summing all B9 cells across the monthly worksheets. I can do
this
for a specified range of months, like =sum(january:December!B9. I want
the
second reference, December, to be variable, like february or september.

I tried indirect but it evaluates the string left to right and
consequently
gives me a name error.

Any suggestions as to how I do this?