I would insert another column and use it to indicate what's in that other column
in that same row.

I'd use C for currency, % for percent, o for other (or anything you want).

Then you could use:

=sumif(b:b,"c",a:a)

to add all the values in column A that had a C in column B.



Bonita wrote:

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

--

Dave Peterson