Welcome Guest.
Asked by: Thompson 172 views IT November 8, 2020
EXCEL How to sum up with text data and without text data
+5Votes
The formula is as follows:
=IFERROR(LEFT(D63,LEN(D63)*2-LENB(D63))+LEFT(E63,LEN(E63)*2-LENB(E63))+ LEFT(F63,LEN(F63)*2-LENB(F63)),””)
Adding IFERROR is to exclude that when the first three cells are empty or have no numbers, the result is displayed as empty.
Rose- November 9, 2020 |
+5Votes
The formula is as follows:
=IFERROR(LEFT(D63,LEN(D63)*2-LENB(D63))+LEFT(E63,LEN(E63)*2-LENB(E63))+ LEFT(F63,LEN(F63)*2-LENB(F63)),””)
Adding IFERROR is to exclude that when the first three cells are empty or have no numbers, the result is displayed as empty.