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