Forum Discussion
SUM VALUE WITH TEXT HAVING BLANK SPACE
Dear All. Please solve this question. I have value in Column A1 to Column A5 numbers and text mentioned below. But there is a blank column A2. I want to do sum skipping blank space therein. Plea...
=SUMPRODUCT(IFERROR(NUMBERVALUE(LEFT(A1:A5,FIND(" ",A1:A5)-1)),0))You can try this formula. Enter the formula with ctrl+shift+enter if you don't work with Office 365 or Excel 2021.