| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
excel formula
I am trying to add numbers from multiple spredsheets in one file.
The file is a timetable file with twelve spredsheets. One for each Month. I am trying to add Cell J40 from 12 spreadsheets as they are entered |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
excel formula
On your 13th (inserted) worksheet (Master - which should be the First
Worksheet (that is furtherest to the left)) in cell J40 enter: Sheet1:Sheet12!J40 (rename Sheet1 and Sheet12 as appropriate) That should do it.. "M@ Brereton" wrote in message om... I am trying to add numbers from multiple spredsheets in one file. The file is a timetable file with twelve spredsheets. One for each Month. I am trying to add Cell J40 from 12 spreadsheets as they are entered |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
excel formula
darn,,, you do know to enter the "=" before the Sheet1:Sheet12!J40 ,
don't you? so that it is =Sheet1:Sheet12!J40 "Jim May" wrote in message news:lNeSc.18597$Bb.9884@lakeread08... On your 13th (inserted) worksheet (Master - which should be the First Worksheet (that is furtherest to the left)) in cell J40 enter: Sheet1:Sheet12!J40 (rename Sheet1 and Sheet12 as appropriate) That should do it.. "M@ Brereton" wrote in message om... I am trying to add numbers from multiple spredsheets in one file. The file is a timetable file with twelve spredsheets. One for each Month. I am trying to add Cell J40 from 12 spreadsheets as they are entered |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
excel formula
Hi, Jim:
How about adding a SUM function in there, too <g, i.e. =SUM(Sheet1:Sheet12!J40) Myrna Larson On Tue, 10 Aug 2004 21:38:38 -0400, "Jim May" wrote: darn,,, you do know to enter the "=" before the Sheet1:Sheet12!J40 , don't you? so that it is =Sheet1:Sheet12!J40 "Jim May" wrote in message news:lNeSc.18597$Bb.9884@lakeread08... On your 13th (inserted) worksheet (Master - which should be the First Worksheet (that is furtherest to the left)) in cell J40 enter: Sheet1:Sheet12!J40 (rename Sheet1 and Sheet12 as appropriate) That should do it.. "M@ Brereton" wrote in message om... I am trying to add numbers from multiple spredsheets in one file. The file is a timetable file with twelve spredsheets. One for each Month. I am trying to add Cell J40 from 12 spreadsheets as they are entered |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
excel formula
opps,
tks, sorry OP tks Myrna "Myrna Larson" wrote in message ... Hi, Jim: How about adding a SUM function in there, too <g, i.e. =SUM(Sheet1:Sheet12!J40) Myrna Larson On Tue, 10 Aug 2004 21:38:38 -0400, "Jim May" wrote: darn,,, you do know to enter the "=" before the Sheet1:Sheet12!J40 , don't you? so that it is =Sheet1:Sheet12!J40 "Jim May" wrote in message news:lNeSc.18597$Bb.9884@lakeread08... On your 13th (inserted) worksheet (Master - which should be the First Worksheet (that is furtherest to the left)) in cell J40 enter: Sheet1:Sheet12!J40 (rename Sheet1 and Sheet12 as appropriate) That should do it.. "M@ Brereton" wrote in message om... I am trying to add numbers from multiple spredsheets in one file. The file is a timetable file with twelve spredsheets. One for each Month. I am trying to add Cell J40 from 12 spreadsheets as they are entered |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| When I enter a formula, Excel shows the formula not the results | Excel Worksheet Functions | |||
| Excel 2002 Formula: Urgent Conditional Formula Required Right Away - if possible | Excel Discussion (Misc queries) | |||
| Build excel formula using field values as text in the formula | Excel Worksheet Functions | |||
| Excel 2002 formula displayed not value formula option not checked | Excel Worksheet Functions | |||
| How do I view formula results intead of formula in excel? | Excel Worksheet Functions | |||
Linear Mode
