How sum only part of numbers in Google sheet column? 20 20 60 = 100

CodePudding user response：

Use SPLIT() then SUM(). Try-

=SUM(INDEX(SPLIT(B4:B6," "),,1))