Googlesheets - Get the sum of a special string column

Vote count: 0

How can I sum up a sheet looks like below:

|-------+-----------|
|     1 | HKD 2,010 |
|-------+-----------|
|     2 | HKD 1,010 |
|-------+-----------|
|     3 | HKD 2,020 |
|-------+-----------|
| Total | HKD 5,050 |
|-------+-----------|

asked 14 secs ago

lucky1928

Let's block ads! (Why?)

Googlesheets - Get the sum of a special string column