Can I sum across closed worksheets ?

[Hollywoood]

Hi all,

I am trying to create a template to be used for several dozen separate profiles. I would then like to be able to create a master file that sources and sums across all of the separate work sheets that are saved in a specific folder without having to have all of them open.

Is there an easy enough way to do this?

So in general id like to be able to do something along the lines of...

sum(c:\files,A1) with the gaol being to retrieve and sum every A1 cell of every worksheet in that folder...

Thanks in advance for any help!

 

[Jerry Sullivan]

So in general id like to be able to do something along the lines of...

sum(c:\files,A1) with the gaol being to retrieve and sum every A1 cell of every worksheet in that folder...

No, you can't reference all files in a folder that way using ordinary formula functions.

The simplest way to do this without the use VBA code would be to make a table listing each file's value and sum them. The fact that files are closed will not prevent you from reading their current values.

Excel Workbook
	A	B
1	Book1	10
2	Book2	10
3	Book3	30
4	Sum	50
Sheet1