sum

[Guest]

Hi
I have 25 diffrent worksheets with diffrent file name. Now i want to get
all the sums in one worksheet.Please guide me

 

[Don Guillett]

terminology
workbook = an excel file with the extension .xls
worksheet=a tab within a workbook

If you mean that you want to total one cell in all worksheets within a
workbook
=sum(sheet2:sheet10!a1) formula in sheet1

 

[Guest]

Open The files on where you want to get you accumulative data from and the do
the following formula:

=sum([File Name]Sheet name!Cell Range+[File Name]Sheet name!Cell Range)

Granted this is the long way of getting what you need but it works rather
well!!