How to sum the numbers with currency in the table

2.

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:

3. If the currency symbol is added to the "currency" format in Excel, it can be directly summed
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)

4. Select a single cell and see if the formula bar shows a number or currency? If it's a direct sum of numbers, if it's signed, use the function formula again!

5. If it's text, extract the number and sum it up
= sum (- - left (A1: B1, len (A1: B1) - 1)
Ctrl Shift, and press enter

6. You should set another currency column to add the data columns of the same unit rows

7. Just set the cell format ~
select the cell in the auto sum column, right-click and select set cell format & gt“ Digital "& gt“ Currency "& gt“ Currency symbol "& gt“ ￥”>“ "Confirm".

8. 1. It's a kind of gem, which can be used to make weapons... Making weapons is the same as alchemy, which requires a certain degree of proficiency
2. When you reach level 3, you can find a place with a lot of people to investigate...
3. You can use mm to buy professional miner's Amulet... Miner's cap... Advanced miner's Amulet... And so on... Which are concive to mining... But you don't agree to buy it, it's too expensive... It's better to use time to change it

9. You can use the "[DS] too many item +" mole, but after using it, you will greatly rece the popularity of the game.