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
|