Short of writing code there is no way I'm aware of to use the format
properties of other cells to arrive at a sum of those cells. However,
if you have a list of Euro figures and Dollar figures, they must be
labeled somehow, probably in a different column, to allow someone
viewing the list to make sense of it all. Is there any commonality
between the Euro labels and the Dollar labels? If yes, then you can
use any of a number of functions to arrive at your totals. What
additional info do you have to work with?