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.


--
aebjeffrey
------------------------------------------------------------------------
aebjeffrey's Profile: http://www.excelforum.com/member.php...o&userid=32167
View this thread: http://www.excelforum.com/showthread...hreadid=519161

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" a
écrit dans le message de
...

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.


--
aebjeffrey
------------------------------------------------------------------------
aebjeffrey's Profile:
http://www.excelforum.com/member.php...o&userid=32167
View this thread: http://www.excelforum.com/showthread...hreadid=519161