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?