Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
taking an average of every 30 cells
I have a column of data that is 3500 cells. I want to get averages of
this data by every 30 cells. Is there any way of doing this besides than manually calculating the average for every group of 30 cells? THanks! |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
taking an average of every 30 cells
Asuming data starts in A1:
in B1: =AVERAGE(OFFSET($A$1,(ROW()-ROW($A$1))*30,,30)) copy down HTH " wrote: I have a column of data that is 3500 cells. I want to get averages of this data by every 30 cells. Is there any way of doing this besides than manually calculating the average for every group of 30 cells? THanks! |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
taking an average of every 30 cells
Hi Donna,
Say your data is in A1:A3500. In B30 put =AVERAGE(A1:A30) Then click on the fill handle and drag down to the end of your data. That will give you a running average of the previous thirty values. Rather than dragging you can also double click on the fill handle which will copy the formula down as far as there is data in column A. HTH Martin wrote in message oups.com... I have a column of data that is 3500 cells. I want to get averages of this data by every 30 cells. Is there any way of doing this besides than manually calculating the average for every group of 30 cells? THanks! |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
taking an average of every 30 cells
THANKS!!
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
taking an average of every 30 cells
Thanks for your help!
|
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Autofilter COUNTA formula not taking into account hidden cells | Excel Discussion (Misc queries) | |||
how to taking a .txt email list that are separated with spaces and sort them in to excel cells | Excel Worksheet Functions | |||
Calculating Cells Taking Forever | Excel Discussion (Misc queries) | |||
taking data from multiple cells and displaying in one cell | Excel Discussion (Misc queries) | |||
Taking data from 3 different cells and adding the components toget | Excel Worksheet Functions |