Without seeing the formulas in C16 and C14 it is hard to answer
But I suggest you start by looking at the INDIRECT function
Then come back and tell us everything we need to know
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
www.stfx.ca/people/bliengme
remove caps from email

"Labman1366" wrote in message
...
I am trying to add the values of two cells which contain links to other
worksheets. Can I do that and how? (Ex.: Cell C6 equation
=SUM(C16+C42).
Cell C16 is linked to Cell f46 of worksheet 6th while Cell C42 is linked
to
Cell F46 of worksheet 8th. A "value" does not appear in either cell as
far
as my equation can tell. How do I get Excel to add the values of the two
cells?