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