★Word/Excel (MS-OFFICE) 初心者スレッド Part41★

[0293 292 2015/11/03(火) 18:29:34.66 ID:???]

｢\｣を消す必要は無かった...
=SUMPRODUCT(REPLACE(A1:A4,1,1,)*1)
=SUMPRODUCT(RIGHT(A1:A4,LEN(A1:A4)-1)*1)