"sheri" wrote in message
...
Hope you can help. I'm trying to enter a formula to calculate year to date
variance from 2004-2005. Data for '04' is on another worksheet. How do I
enter the formula
I'm using Excel 2003.


In the cell you want the variance to appear, type "+" (without the quotes),
then click on the Year to Date total on the 05 sheet, then type "-" (again
without the quotes), then click on the 04 sheet tab, and click on the 04 YTD
total cell. Hit "enter". Job done!