Help with cell references, please

[steve]

TIA

I have an application that logs multiple data points at one minute
intervals and writes them to a file every 24 hrs. - thus I get a file
with "n" number of columns and 1440 rows of numbers every day. The file
names are of the form 20040113 corresponding to the date.

I now need to go back thru 90 days of these files, single out a
particular column of interest, take an average of those 1440 numbers and
populate another worksheet with those averages so I can chart 90 days of
them.

I think I need to use a for-next loop to increment both the date and the
averages-worksheet cell reference but I'm having trouble coming up with
the proper format for the references. (Since I only need 90 days, it's
probably easier to do for a one month period at a time rather than
dealing with incrementing the date format through the months.)

I suppose I could just go back and do it all manually but I'd rather
learn the proper way.

Hopefully this makes sense and thanks again for the help you all offer.

 

[Ozzie]

in a new worksheet in whatever cell you want;

=AVERAGE([20040113.xls]Sheet1!$A$1:$A$1440)

Copy down 89 rows and then change the 20040113 to
20040112, 20040111..

Then you can average your average (in row 91)

I'm sure there is an easier way to do all this.


ozzie