總和 起迄號間 用VLOOKUP (9032)

E10{=SUM(IFERROR(VLOOKUP(N(IF({1},ROW(INDIRECT(E2&":"&E6)))),B:C,2,),))

一般用 E11=SUMIFS(C:C,B:B,">="&E2,B:B,"<="&E6)

序號連續{=SUM(LOOKUP(ROW(INDIRECT(E2&":"&E6)),B:C))