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 |

+5

VotesThe 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 |