Re: over my head

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

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" <James@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message news:2B894F54-5D8C-41DA-8D7B-7DE4488F32FA@xxxxxxxxxxxxxxxx
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
>



.

Quantcast