B3:B6{=SUM(N(ROW(INDIRECT(10^(A3-1)&":"&10^A3-1))=MMULT(MID(ROW(INDIRECT(10^(A3-1)&":"&10^A3-1)),TRANSPOSE(ROW(INDIRECT("1:"&A3))),1)*1,10^(ROW(INDIRECT("1:"&A3))-1))))
C3:C6{=SUM((ROW(INDIRECT(10^(A3-1)&":"&10^A3-1))=MMULT(MID(ROW(INDIRECT(10^(A3-1)&":"&10^A3-1)),TRANSPOSE(ROW(INDIRECT("1:"&A3))),1)*1,10^(ROW(INDIRECT("1:"&A3))-1)))*ROW(INDIRECT(10^(A3-1)&":"&10^A3-1)))
留言
張貼留言