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
|