summing from arbitrary list of workbooks

D

Don H

Does anyone know how to state a function that sums the
same cell in a list of workbooks, where that list may vary
from time to time?

What I really would like is to be able to use a reference
such as =SUM([*.xls]A15) and have that sum the cell from
any spreadsheets in the current directory. This
particular syntax, though, is not valid.

I could build a macro that searched the directory, and
then built the necessary function arguments, cell by cell,
but this is both inelegant and a drag to do.

Anyone have any clever solutions? Thanks
-don
 
F

Frank Kabel

Hi Don
AFAIK not possible without using VBA if the other workbooks could be
closed
 
G

Guest

Thanks for your reply, Frank... I'm afraid you're probably
right, but still maintain a speck of hope that someone out
there may know of some clever solution.
-don
-----Original Message-----
Hi Don
AFAIK not possible without using VBA if the other workbooks could be
closed

--
Regards
Frank Kabel
Frankfurt, Germany


Don said:
Does anyone know how to state a function that sums the
same cell in a list of workbooks, where that list may vary
from time to time?

What I really would like is to be able to use a reference
such as =SUM([*.xls]A15) and have that sum the cell from
any spreadsheets in the current directory. This
particular syntax, though, is not valid.

I could build a macro that searched the directory, and
then built the necessary function arguments, cell by cell,
but this is both inelegant and a drag to do.

Anyone have any clever solutions? Thanks
-don
Click to expand...

.
Click to expand...
 
Top