Average count of cells

[Coastal Cat]

How can l average a number in a cell, it is the same cell in the same
sheet, but in a number of different workbooks (about 360) in a total of
12 folders.

 

[Bernard Liengme]

I think I would get the data onto a blank workbook first with formula such
as
='C:\Documents and Settings\Owner\My
Documents\SampleFolder\[Book1.xls]Sheet1'!$A$1
Then compute the average.
Hopefully the folder names are such that you could 'compose' them in an
INDIRECT statement. Tell some sample folder names.

 

[Frank Kabel]

I think I would get the data onto a blank workbook first with formula
such as
='C:\Documents and Settings\Owner\My
Documents\SampleFolder\[Book1.xls]Sheet1'!$A$1
Then compute the average.
Hopefully the folder names are such that you could 'compose' them in
an INDIRECT statement. Tell some sample folder names.

Hi Bernard
I don't think INDIRECT will work as probably not all workbooks are
opened as this is a prerequisite for the INDIRECT function
Maybe INDIRECT.EXT from the add-in MOREFUNC.XLL will help
(http://longre.free.fr/english)


Frank

 

[Bernard Liengme]

Thanks - I had overlooked that "little" fact!

--
Bernard Liengme
www.stfx.ca/people/bliengme
remove CAPS in e-mail address

I think I would get the data onto a blank workbook first with formula
such as
='C:\Documents and Settings\Owner\My
Documents\SampleFolder\[Book1.xls]Sheet1'!$A$1
Then compute the average.
Hopefully the folder names are such that you could 'compose' them in
an INDIRECT statement. Tell some sample folder names.

Hi Bernard
I don't think INDIRECT will work as probably not all workbooks are
opened as this is a prerequisite for the INDIRECT function
Maybe INDIRECT.EXT from the add-in MOREFUNC.XLL will help
(http://longre.free.fr/english)


Frank