View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
CaitlinRVH CaitlinRVH is offline
external usenet poster
 
Posts: 2
Default 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