If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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 |
Thread Tools | |
Display Modes | |
|
|