adding cells from different workbooks

  • Thread starter Thread starter joeldsmt
  • Start date Start date
J

joeldsmt

I posted one just before but it did not go through.... so here goes.

I just want to add the same cell on differerent workbooks and put th
value on a separate workbook.

I track my monthly sales on individual workbooks and i want to have
year to date file with all the values on one sheet.

Exp....
WORKBOOK1 SHEET1 CELL C5 add to
WORKBOOK1 SHEET2 CELL C5 add to
WORKBOOK1 SHEET3 CELL C5 etc....

add all of these together and put them on

WORKBOOK1 SHEET13 CELL C5

anyone able to help me here. Im spent.

Thank yo
 
Did you mean different worksheets or different workbooks? Your eaxampl
is worksheets but you mention workbooks.
To answer your question wrt worksheets. Put the following into Sheet1
cell C5

=+Sheet1!C5+Sheet2!C5+Sheet3!C5

If you meant workbooks then it will be something like

=+[workbook1.xls]Sheet1!$C$5+[workbook2.xls]Sheet1!$C$5+[workbook3.xls]Sheet1!$C$5

Hope that helps
 
Filky,

I meant workbook.

Is there a limit? i used ABS to do this same function as well as SU
and they only let me use 5 workbooks.

thank
 
I'm not aware of a limit but I'm sure there is one. 5 sounds a littl
small. I know you can get issues with the amount of data in
particular cell sometimes but I can't help with this one
 
thanks.

I did what you said and it worked just fine.

Only problem now is this.... i am trying to do this to all the cells o
each page. what i mean is... not only one cell i want to sum up an
put on the final page but to all the cells on each sheet.

Any ideas? normally i just copy the original cell that i put th
formula in and it automatically moves one step but this time it jus
put the exact formula as above...

any suggestions
 
Yes. The $C$5 means always go the cell C5. If you replace the first on
as $C5 then drag it'll work
 
Have you tried this to total all the twelve C5 cells in a single C5 cell on
sheet13?

=SUM(Sheet1:Sheet12!C5)
--

HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================


all worked great!!!

Thanks!
 
Back
Top