over my head

[James]

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

 

[T. Valko]

need to pick up every 7th cell

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

The interval isn't consistent. It starts at 6 and then goes to 7.

So, based on that try this:

=I105+SUMPRODUCT(--(MOD(ROW(I111:I170)-ROW(I111),7)=0),I111:I170)

Adjust the end of the range as needed.

 

[Rick Rothstein \(MVP - VB\)]

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]

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\)]

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

 

[Rick Rothstein \(MVP - VB\)]

Also, why are the differences between the rows you cited (103, 109, 116,
etc.) not constant (some differ by 6 and others by 7)? Is there a rule to
govern this variability in the differences?

Rick