Thread: over my head
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
James James is offline
external usenet poster
 
Posts: 542
Default 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