Auto Formula to Next Row
 

I'm working on summarizing data from a survey. On the summary I need to
refer back to a worksheet that lists all responses in 28 columns (each column
represents a question). I am hoping to set up a macro/formula that will
count the number of responses for each question without having to retype the
=counta formula for each column... Similarly, I need a formula which
averages each question's responses without having to retype the =average
formula for every column. Any help is appreciated!!