| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Head to head | Excel Discussion (Misc queries) | |||
| In over my head with calendar 8.0 | Excel Worksheet Functions | |||
| Formula. Way over my head | Excel Discussion (Misc queries) | |||
| Cant get my head around this one | Excel Worksheet Functions | |||
| Over my head on this one... | Excel Worksheet Functions | |||
Threaded Mode
