Beautiful.=SUMPRODUCT(--MID(SUBSTITUTE(A1,"/",""),ROW(INDEX(A:A,1):INDEX(A:A,LEN(SUBSTITUTE(A1,"/","")))),1))
This wouldn't work if there was a double digit number, will it? Like 0/11/2/0/3, the answer should be 16 but the formula gives 7.=SUMPRODUCT(--MID(SUBSTITUTE(A1,"/",""),ROW(INDEX(A:A,1):INDEX(A:A,LEN(SUBSTITUTE(A1,"/","")))),1))
Cell Formulas | ||
---|---|---|
Range | Formula | |
B1 | =Calc | |
C1 | =Eval(A1) |
Named Ranges | ||
---|---|---|
Name | Refers To | Cells |
Calc | =EVALUATE(SUBSTITUTE(!B3,"/","+")) |