Why is the automatic sum 0?
As shown in the picture, even if I use the summation function sum to calculate the result, the result is still 0.
Generally, this can be solved by right-clicking on the summed data and setting the cell format to numerical value.
#But what is intoxicating is that after setting it to a numerical value, the result is still 0.
#This means that the table data contains hidden strings and cannot be summed.
So we can use the len function to test the length of the table data.
As shown in the figure, the result of the len function test shows that the table has 6 characters instead of 5. This hidden character may be at the beginning or at the end of the data.
#So you can use the replace function to test where the characters are.
For example, I will replace the first character at the beginning of F2 with / and try the result.
After pressing Enter, if you see an extra slash in front of the data, it means that the hidden character is in front.
#After that, we can select a cell range of the same number and start batch conversion of the data.
Then enter the replace formula in the edit bar and press Ctrl and press Enter to apply the formula in batches.
#Then press Ctrl and C to make a copy of the batch converted data.
Then find a column of cells and right-click to select the "123" format to paste.
#Then convert the pasted data into digital format and you can perform the sum calculation.
The above is the detailed content of Why is the automatic summation 0?. For more information, please follow other related articles on the PHP Chinese website!