| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Add sum of cell from another worksheet
I don't get an error with this code but it also doesn't pick up the content
of the cell I'm trying to grab from. The cell is an = adding totals from numerous tabs in a worksheet all totaled at June2!L32. Here's the code. =[2006Digital.xls]June2!L32+July1!J29+July2!J29+Aug1!J29+Aug2!J29+Se pt1!J29+Sept2!J29+Oct1!J29+Oct2!J29+Nov1!J29+Nov2! J29+Dec1!J29+Dec2!J29 And here's where it originates in 2006Digital.xls at L32: =Jan1!J29+Jan2!J29+Feb1!J29+Feb2!J29+Mar1!J29+Mar2 !J29+Apr1!J29+Apr2!J29+May1!J29+May2!J29+June1!J29 +June2!J29 Any assistance is greatly appreciated! |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How:Add New Worksheet that copies the cell of the previous sheet | Excel Worksheet Functions | |||
| How do I get ONLY new info from 1 Worksheet to another automatical | Excel Worksheet Functions | |||
| fill cell with color from other worksheet | Excel Discussion (Misc queries) | |||
| Conversion of Cell Contents into a Functional Worksheet name ? | Excel Worksheet Functions | |||
| Refrencing another cell in a worksheet that "could" exist | Excel Worksheet Functions | |||
Threaded Mode
