Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Average every x cells
I am trying to average data in a column from every 4 cells together. For
example, if data is in column A, then average A1:A4, A5:8,... Then put the results in contiguous cells in column B. B1 would have average of A1:A4, B2 average of A5:A8, ... Thanks in advance |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Average every x cells
In article ,
Wox wrote: I am trying to average data in a column from every 4 cells together. For example, if data is in column A, then average A1:A4, A5:8,... Then put the results in contiguous cells in column B. B1 would have average of A1:A4, B2 average of A5:A8, ... Thanks in advance Try... B1, copied down: =AVERAGE(INDEX($A$1:$A$100,ROWS(B$1:B1)*4-4+1):INDEX($A$1:$A$100,ROWS(B$1 :B1)*4)) -- Domenic http://www.xl-central.com |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Average every x cells
Thanks Domenic, this works great.
Thanks tons "Domenic" wrote: In article , Wox wrote: I am trying to average data in a column from every 4 cells together. For example, if data is in column A, then average A1:A4, A5:8,... Then put the results in contiguous cells in column B. B1 would have average of A1:A4, B2 average of A5:A8, ... Thanks in advance Try... B1, copied down: =AVERAGE(INDEX($A$1:$A$100,ROWS(B$1:B1)*4-4+1):INDEX($A$1:$A$100,ROWS(B$1 :B1)*4)) -- Domenic http://www.xl-central.com |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Average every x cells
Here's another one. More compact but volatile (will recalculate any time a
calculation takes place). Entered in B1 and copied down: =AVERAGE(OFFSET(A$1,ROWS(B$1:B1)*4-4,,4)) -- Biff Microsoft Excel MVP "Wox" wrote in message ... I am trying to average data in a column from every 4 cells together. For example, if data is in column A, then average A1:A4, A5:8,... Then put the results in contiguous cells in column B. B1 would have average of A1:A4, B2 average of A5:A8, ... Thanks in advance |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
zero value cells/blank cells causing error in AVERAGE? | Excel Worksheet Functions | |||
from a group of cells.find average of cells containing values | Excel Discussion (Misc queries) | |||
Excel-only average cells if two cells in same row, meet two condit | Excel Worksheet Functions | |||
average cells, show 0 if nothing to average | Excel Discussion (Misc queries) | |||
average 2 cells (Mileage Divide by Gallons in two cells | Excel Discussion (Misc queries) |