Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|