Description: Calculates averages over blocks of N cells. When
there are M values in the range, M/N averages are
calculated, for each block of N values an average is computed
and returned.
BlockAverage is an array function, it returns more than one value.
Select a range of cells, one column and more than one row. Enter the
formula and press Ctrl Shift Enter simultaneously. This will create the
array function in Excel.
Example: Calculation of 20 block averages. Block size
is 5. The first value is the average of A1:A5, the second value is the
average of A6:A10, etc. =BlockAverage(A1:A100,5)
Copyright (C) 1995-2010 Linker IT
Software BV. All Rights Reserved. Oracle is a registered trademark of
Oracle corporation. Excel and Office are registered trademarks of
Microsoft corporation. Other names appearing on the site may be trademarks
of their respective owners. Software,
files, documents, articles and other material are provided
"as is" and without warranties as to performance or mechantability or
any other warranties whether expressed or implied. No
warranty of fitness for a particular purpose is offered.
sitemap
