Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
average of column
This is a really simple one for most of you, but I'm trying to do the average
of one column, put the average in the cell below the column, then copy that average across several other columns to the right. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
average of column
Use the AVERAGE() Function in a cell. Select the cell you want the average
in and type this: =AVERAGE(A1:A30) You will have to change the range to fit your needs. Hope this helps! -- Cheers, Ryan "lostinexcel" wrote: This is a really simple one for most of you, but I'm trying to do the average of one column, put the average in the cell below the column, then copy that average across several other columns to the right. |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
average of column
Say that you want to average columns A through D with the numbers starting
in row 2: Sub PutInAverages() Dim myRow As Long myRow = Cells(Rows.Count,1).End(xlUp).Row Cells(myRow +1,1).Resize(1,4).Formula = "=AVERAGE(A2:A" & myRow & ")" End Sub HTH, Bernie MS Excel MVP "lostinexcel" wrote in message ... This is a really simple one for most of you, but I'm trying to do the average of one column, put the average in the cell below the column, then copy that average across several other columns to the right. |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
average of column
Thank you for the response. It worked.
"lostinexcel" wrote: This is a really simple one for most of you, but I'm trying to do the average of one column, put the average in the cell below the column, then copy that average across several other columns to the right. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
compare cells in column to criteria, then average next column cell | Excel Worksheet Functions | |||
calculate average in a column based on criteria in another column | Excel Discussion (Misc queries) | |||
Sum/average numbers in column A dependant on value in column B | Excel Worksheet Functions | |||
Column chart with additional "average" column | Charts and Charting in Excel | |||
vba: Taking average of values in one column based on a corresponding value in another column | Excel Programming |