sum

M

Mathew

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

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
 
F

fluffymoore

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