Regarding: ='FY04'!H9

That formula references cell H9 on the FY04 sheet located in the same
workbook.

For more information, search Excel help for "references"

Does that help?
***********
Regards,
Ron

XL2002, WinXP


"Merritt" wrote:

I am continuing a worksheet that someone else createdIt has columns for
fiscal years 1993 throu 2004. I have added a column for 2005. Antoher
column contains the current year information in dollars, the column for 2005
is based on formulas which I understand. However, in the previous year
columns, the cells contain a formula similar to this ='FY04'!H9. I'm
thinking that it has something to do with freezing the cells so that when I
enter the current year dollars, the prior year cells don't change. When I
put a similar formula into last years cells, I get an invalid address error
message. I've never seen the above formula before and it's not listed on the
"About Calculation Operators" page.