View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
drumz drumz is offline
external usenet poster
 
Posts: 17
Default 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!