How to calculate sum in google spreadsheet?

Question

Google Sheets

Hello. Tell me how you can calculate the values ​​in one column of a Google spreadsheet, if there are values, for example, "$10.00".

Answer 1

Ideally, you need to convert from a text format to a monetary format.
That is, so that the value is 10, and the format is, for example, US dollar.

meaning:

format:

Then it will be possible to sum up with the usual sum formula, which applies to any numbers:
=SUM(A1:A50)- sum 50 cells in column A.

Answer 2

=VALUE(SUBSTITUTE(SUBSTITUTE(A1;"$";"");".";","))

In the picture "Kalk", but in GT it will work.