Add the Content of a number of cells from multiple worksheet

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a folder with a number of identical workbooks each one saved under a
different department.

Each workbook contains 13 worksheets identified as Wk1 to Wk13 representing
13 weeks

In week 13 I wish to identify in cell P5 the total of the contents of cell
M5 in each of the 13 worksheets. I have tried several formulations but I
either get an error message or it brings up the folder with all the workbooks
as if I have hit the open icon.
Each of the M5 cells will only have a number in it.

Any help would be appreciated--
with kind regards
Mick
 
Mick,

In simplest terms you would reference to only one cell. So P5 can only
return the value of one cell. To do this -
Place the cursor in P5
Hit =
Take the cursor to one of the worksheets
Place the cursor in cell M5
Hit <enter>

That will return the value of cell M5 in worksheet x at cell P5 in worksheet
y
If the worksheet to which the formula refers is in the same spreadsheet the
reference will change as the structure (layout) is changed. If, however,
the worksheet to which the formula refers is NOT in the same spreadsheet the
reference will NOT change as the structure (layout) is changed and the
output will be incorrect.

To get round this problem you should first name the target cells. To do
this -
Place the cursor in the target cell
Click on <Insert><Name><Define>
Type in a name (e.g.Total)
Click <OK>
and continue as above

If you want the total of the 13 Cells P5 after hitting <enter> -
insert = at the end of the formula and just go round again until all 13
cells are included in the formula.

Regards.

Bill Ridgeway
Computer Solutions
 
Back
Top