You could use a help column, assume the values are in A1:A10, insert a new
column B and in B1 put

=LEFT(CELL("format",A1))="C"

copy down to B10

now use

=SUMIF(B1:B10,TRUE,A1:A10)

having said that, it is not a good design to use this method, all it takes
is that
someone changes one format by mistake and your totals will be off


--
Regards,

Peo Sjoblom

"Bonita" wrote in message
...
If a column of data consist of currency, % and unformatted numbers, how do
you total only the data formated as currency?
--
Bonita