How to sum mixed letters and numbers in excel

How to do mixed sum of letters and numbers in excel: First open the software and enter the alphanumeric superimposed text to be calculated; then enter the relevant formula in the bulletin column and hold down "CTRL SHIFT ENTER" on the keyboard at the same time. calculate.

The operating environment of this article: Windows 7 system, Microsoft Office Excel 2010 version, Dell G3 computer.

Method for summing mixed letters and numbers in excel:

1. The first step we have to do is to open the WPS software program

2. Next we can click to create a new Excel document

3. Enter the alphanumeric overlay text to be calculated and click on the next unit box, enter "="

4. In the public bulletin column above, enter "SUMPRODUCT(TEXT(LEFT(TEXT(MID(A9&"a",COLUMN(1:1 ),ROW($1:$5)),),ROW($1:$5)-1),"0%;-0%;0;!0")*ISERR(-MID(A9,COLUMN(1:1) -1,2)))" Note: A9 inside is the cell to be calculated. You can change it according to the situation

5, and then press and hold " CTRL SHIFT ENTER" to calculate, pull down the calculation data to copy the formula calculation

##Related learning recommendations:

excel tutorial

The above is the detailed content of How to sum mixed letters and numbers in excel. For more information, please follow other related articles on the PHP Chinese website!