Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Pasting an equation down a column
I am analyzing a 45,000 row and 4 column data. I am looking to take the mean
of the 4 columns for all 45,000 without having to type the equations individually. I understand that to get the average for columns C through F I must enter the following formula: =(C3+D3+E3+F3)/4 I would very much appreciate it if someone could inform me how to get the general =(C+D+E+F)/4 formula easily for the entire column. Thank you. Caitlin |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Pasting an equation down a column
CaitlinRVH
Select the cell with the formula & place your curser over the lower right corner of that cell. You are looking for the curser to change from a large white plus sign to a smaller black plus sign (+). When you have that just double click on it and it will fill the formulas to the end of your data or the first blank cell, which ever comes first. Or when you find that smaller plus sign you can drag it all the way down to the end of your data. Mike Rogers -- The only dumb question is the one you did not ask. "CaitlinRVH" wrote: I am analyzing a 45,000 row and 4 column data. I am looking to take the mean of the 4 columns for all 45,000 without having to type the equations individually. I understand that to get the average for columns C through F I must enter the following formula: =(C3+D3+E3+F3)/4 I would very much appreciate it if someone could inform me how to get the general =(C+D+E+F)/4 formula easily for the entire column. Thank you. Caitlin |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Pasting an equation down a column
Hi
You could use =AVERAGE(C1:F1) for the row =AVEARGE(C1:F45000) for the complete range If you want the average of each row separately, then with the first formula in G1, hover the cursor over the bottom right corner of cell G1 till you see a small solid black cross (the fill handle) and double click. It should fill the formula down through G2:G45000 -- Regards Roger Govier "CaitlinRVH" wrote in message ... I am analyzing a 45,000 row and 4 column data. I am looking to take the mean of the 4 columns for all 45,000 without having to type the equations individually. I understand that to get the average for columns C through F I must enter the following formula: =(C3+D3+E3+F3)/4 I would very much appreciate it if someone could inform me how to get the general =(C+D+E+F)/4 formula easily for the entire column. Thank you. Caitlin |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Pasting an equation down a column
Thank you very much!
"Mike Rogers" wrote: CaitlinRVH Select the cell with the formula & place your curser over the lower right corner of that cell. You are looking for the curser to change from a large white plus sign to a smaller black plus sign (+). When you have that just double click on it and it will fill the formulas to the end of your data or the first blank cell, which ever comes first. Or when you find that smaller plus sign you can drag it all the way down to the end of your data. Mike Rogers -- The only dumb question is the one you did not ask. "CaitlinRVH" wrote: I am analyzing a 45,000 row and 4 column data. I am looking to take the mean of the 4 columns for all 45,000 without having to type the equations individually. I understand that to get the average for columns C through F I must enter the following formula: =(C3+D3+E3+F3)/4 I would very much appreciate it if someone could inform me how to get the general =(C+D+E+F)/4 formula easily for the entire column. Thank you. Caitlin |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Pasting an equation down a column
Debra Dalgleish shows how to do what Mike explained (but with pictures):
http://contextures.com/xlDataEntry01.html And she explains another way using the keyboard, too. CaitlinRVH wrote: I am analyzing a 45,000 row and 4 column data. I am looking to take the mean of the 4 columns for all 45,000 without having to type the equations individually. I understand that to get the average for columns C through F I must enter the following formula: =(C3+D3+E3+F3)/4 I would very much appreciate it if someone could inform me how to get the general =(C+D+E+F)/4 formula easily for the entire column. Thank you. Caitlin -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Pasting link in row as column | Excel Discussion (Misc queries) | |||
how to get an equation to update everytime a column is inserted? | Excel Discussion (Misc queries) | |||
Pasting into a column | Excel Discussion (Misc queries) | |||
copying a column and pasting as a row... | Excel Discussion (Misc queries) | |||
How to make one column be the result of an equation between two | New Users to Excel |