→ freePrester: 樓主的想法可用 INDIRECT 配合 ADDESS 06/06 08:03
→ freePrester: =SUM(INDIRECT(ADDRESS(4,7*B8-5)&":"&ADDRESS(4,7*B 06/06 08:03
→ freePrester: 8+1))) 06/06 08:03
→ freePrester: 提供 OFFSET 的方法 06/06 08:03
→ freePrester: =SUM(OFFSET($B$4,0,7*B8-7,1,7)) 06/06 08:04
→ freePrester: 更正 ADDRESS 06/06 08:08
推 windknife18: O365 有 sequence 可以玩看看 06/06 11:23
→ windknife18: B9 =SUM(INDEX(4:4,,SEQUENCE(7,,7*(B8-1))+2)) 06/06 11:23