How to sum numbers with currency quickly in Excel
Reason: the currency symbol in front of the number is another input character, not a numerical format, so the summary operation cannot be performed
solution:
1. First, input the data content with currency symbol in Excel
1. First, open the table to be set on the computer, click the letter at the top of the cell, and select the whole column
If A1: A13 is a number with RMB symbol (in fact, it is already text), then enter the formula = superproct (- - substitute (A1: A23, & quot; ￥",)) That is to sum. See the figure below:
if it is added manually and cannot be operated by operator, the following method can be used:
suppose there are two such numbers in A1 and A2 lattices, and when adding:
= right (A1, len (A1) - 1) + right (A2, len (A2) - 1)
= sum (- - left (A1: B1, len (A1: B1) - 1)
Ctrl Shift, and press enter
For the content summation with unit, the left, mid, right and other functions should be used to extract the number in the cell, which increases the workload.
it is suggested that if column a in the figure, the unit is yuan, then select column a --- Set cell lattice format --- custom --- write in type --- g / general format "Yuan" or 0 "Yuan" ---- confirm
so that the number written in column a will automatically bring unit "Yuan", And this format does not affect the calculation of formula
-
create a new EXCEL table, and make a simple table of building area statistics as shown in the figure according to the requirements of leaders
