Repeating a formula across mulitple columns

  • Thread starter Thread starter aebjeffrey
  • Start date Start date
A

aebjeffrey

I am analyzing data from a measure with two scales. There are 8 total
questions in each measure. Answers from Respondent #1 will in column 1
in excel (rows a1 through a8). I have 100 respondents. Here is the
dilemma, questions 1,2,3, 5 make scale #1 while questions 4,6,7,8 make
scale #2.

Since I have so many respondents I would like to set up a formula where
I can sum the cells that represent the respective scales (sum=
a1,a2,a3,a5 / sum= a4,a6,a7,a8) but I want this apply this formula to
columns 1-100 individually without having to create a new formula for
each column.

Do you have any ideas how to do this? Please ask more questions if this
seems unclear.
 
Are all Respondents aligned on the same row?
100 respondents * 8 colomns = 800 > max.

So I presume Respondents are aligned one per row
Last used colum on each row = 8

Am I right?

If so, just enter =SUM(A1,A2,A3,A5)/sum(A4,A6,A7,A8) into cell A9
Select A9
Press Shift+Down arrow down to the bottom of your array
Press F2, then
"aebjeffrey" <[email protected]> a
écrit dans le message de
news:[email protected]...
 
Back
Top