If there is non-numerical character in the data, it's being stored as a string, whereas only integers (or floating point numbers) can be summed.
To sum the data, you will need to:
Of course, the final output will no longer have dollar signs, but you can indicate the unit in the column header.