sum
 

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

sum
 

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


--
Don Guillett
SalesAid Software

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

sum
 

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!!

"Mathew" wrote:

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