Averaging problem in Excel97
Posted by Graham on October 17, 2000 4:07 AM
Hi
I've got a large table of data downloaded from an automatic logger every thirty seconds or so. I need to produce 15 minute averages - which results in about 44 rows in a column being averaged to produce the result.
the problem is that the next 44 rows are for the next 15 minute average. as my summary table is right at the bottom (at row 4000 and something), can I adjust the averaging function so that the first cell looks at the first 44 and then the next cell down in the summary table looks at the second 44 rows and so on
(obviously I could type average(f1:f44) and then average(f45:89) in each cell etc etc down the rows of the summary table but surely there must be a more elegant way?)
thanks
Graham