Average count of cells

  • Thread starter Thread starter Coastal Cat
  • Start date Start date
C

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.
 
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.
 
Bernard said:
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.
Click to expand...

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
 
Thanks - I had overlooked that "little" fact!

--
Bernard Liengme
www.stfx.ca/people/bliengme
remove CAPS in e-mail address
Frank Kabel said:
Bernard said:
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.
Click to expand...

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
Click to expand...
 
Back
Top