Linker IT Software
Order Home
menubar-top-links menubar-top-rechts
SQL*XL: Database to Excel bridge ExcelLock: Lock and secure your valuable Excel spreadsheets encOffice: Protect your Excel file easy and safe
Home Products litLIB Help Numeric functions

Buy now

Download now

LITlib - Excel Power Functions Pack
Add-in for Excel that adds additional cell functions to Excel.

litLIB Help - BlockAverage function
litLIB Help
Product pages :
Quick links:
help index

Numeric - BlockAverage

=BlockAverage(Range, N)

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.

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.