Getting the sum of a specific number in a cell-CodePudding

Home > front end > Getting the sum of a specific number in a cell

Getting the sum of a specific number in a cell

Time：10-08

I just want to get the sum of all the values on the left side and not include the date.

CodePudding user response：

Try SUMPRODUCT(). Assuming, you have space after value.

=SUMPRODUCT(--LEFT(A1:A4,SEARCH(" ",A1:A4)))

CodePudding user response：

Hey, Try this, even the data is inconsistent with more spaces, this will work.

=SUMPRODUCT(LEFT(A2:A6,SEARCH("-",SUBSTITUTE(A2:A6," ",""))-1) 0)

CodePudding user response：

What about:

=SUM(--TEXTSPLIT(A1:A4," "))