excel formula

  • Thread starter Thread starter M@ Brereton
  • Start date Start date
M

M@ Brereton

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
 
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..
 
darn,,, you do know to enter the "=" before the Sheet1:Sheet12!J40 ,
don't you?
so that it is =Sheet1:Sheet12!J40
 
Hi, Jim:

How about adding a SUM function in there, too <g>, i.e.

=SUM(Sheet1:Sheet12!J40)

Myrna Larson
 
opps,
tks,
sorry OP
tks Myrna

Myrna Larson said:
Hi, Jim:

How about adding a SUM function in there, too <g>, i.e.

=SUM(Sheet1:Sheet12!J40)

Myrna Larson
Click to expand...
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel Handicap Formula 0
PDF files 1
Sum If and Count If 2
Formula in Excel for stock control records 0
access export to excel cell spacific 3
Sum Cells based on attributes 5
How do I copy spreadsheets with charts? 2
How do I insert a sheet row when that option is grayed out? 1

Back
Top