over my head
 

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

over my head
 

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.

--
Biff
Microsoft Excel MVP


"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

over my head
 

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

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 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

over my head
 

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

over my head
 

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


"Rick Rothstein (MVP - VB)" wrote in
message ...
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