How can I manipulate the cell format so that I can display it with a currency sign and still be able to sum()?

Is there a way to set the cell format as a currency so that In my cell I would have values like € 100,00 in H8:H10 and in the exported file I could Sum() them in Cell K12 ?