更正:
A1 1
A2 2
A3 3
A4 4
A5 Sumup=10 <= This is text input, not formula
A6 5
A7 6
A8 7
A9 8
A10 Sumup=26 <= formula
A11 1231
A12 12312
A13 Sumup=13543 <= copy from A10
A14 a
A15 d
A16 123
A17 2
A18 Sumup=125 <= copy from A10
A26 formula:
="Sumup="&(SUM(A$1:A9)-SUM(INDIRECT(("A1:A"&LOOKUP(2,1/(ISTEXT(A$1:A9)),ROW(A$1:A9))))))
好處:
不用Array formula
壞處:
第一個sumup 一定手動入, 不能formula