I'm still having trouble picturing your layout. Are you saying you have the
name repeated on Rows 103, 109, 116, etc. with your different section's data
under each one?
Rick
"James" wrote in message
...
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 sheet 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 worksheet. 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" wrote in message
...
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