
01-13-2017, 08:46 AM
|
Expert
|
|
Join Date: Apr 2016
Posts: 673
|
|
Maybe, with + 19 + 1 in A1...
=SUM((TRIM(MID(SUBSTITUTE(A1,"+",REPT(" ",255)),1+(ROW(A1:A200)-1)*255,255)) & "0")/10)
IMPORTANT- This is an array formula
- Enter the formula >> press F2 then >> CTRL + SHIFT + ENTER
- If entered correctly, the formula will be enclosed in {brackets}
- Do not enter the {brackets} manually
|