和 重複累加 (8980)

C2=SUMPRODUCT(({1,2,3}>={1;2;3})*A1:A3)

另解=SUM(SUBTOTAL(9,OFFSET(A1,,,{1,2,3})))

另解=SUM(MMULT(N(ROW(1:3)>=COLUMN(A:C)),A1:A3))

另解=SUM(SUMIF(OFFSET(A1,,,{1,2,3}),"<>"))