Re: over my head

OK ... the rows are fixed and will not get any bigger, on a couple of other
pages i take raw weekly data from customer surveys and sort it by individuals
staff members. on this *** i have rolled it up by week, each week uses
about six rows for different types scores under that individual then a blank
row and start week two, I track a total of eight weeks. all of those columns
and rows are fixed and will not change. then names are in row's 103, 109,
116, 123, 130, 137, 144, 151 you are correct with the column & sums. I hope
this helps, like i said i think im over my head on this one

"Rick Rothstein (MVP - VB)" wrote:

I think it might help if you describe the setup for your work***. What row
are the names in? What column do the names start at (I'm guessing "I")? What
column do they end at (I'm guessing "CU"... if right, is that a fixed end
for the list of names or could it change)? Where are the sums going (I'm
guessing 154... if right, is that a fixed location for them)? Anything else
you think might help us understand your layout (as it applies to your
particular question)?

Rick

"James" <James@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:D011947E-9728-4EAA-BDFA-075024080B74@xxxxxxxxxxxxxxxx
is it possible to combine these two formulas? i have a list of names going
across a row then i need to pick up every 7th cell going down the column
for
each name and sum that value. is this even possible to do without having
to
scroll and +? im going crazy!!

=INDEX($I$154:$CU$154,ROWS(154:$154)*6-5)

=I105+I111+I118+I125+I132+I139+I146+I153



.