Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Trying to SUM cells with links.
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? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Trying to SUM cells with links.
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? |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Trying to SUM cells with links.
If C16 and C42 contain values, then all you need is =C16+C42 [or you can use
=SUM(C16,C42), but you don't need =SUM(C16+C42)]. What formula do you have in C16, and in C42? If C16 is something like =6th!F46, then it should work provided that 6th!F46 contains a value. You may need to trace on back through the chain to see whereabouts you don't have a value. -- David Biddulph "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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Links in Cells | Excel Discussion (Misc queries) | |||
detect cells with links | Excel Worksheet Functions | |||
Excel XP cells are links | Excel Discussion (Misc queries) | |||
Links into blank cells | Excel Discussion (Misc queries) | |||
cells with links | Excel Discussion (Misc queries) |