it depends on how thee colors are applied.
If the colors are from conditional or custom formating. the same criteria
for the formating can be used in a sumproduct() or similar formula.
If the colors were changed by hand, a macro will be needed.
something like the one in
http://www.cpearson.com/excel/colors.htm


"24 Jan 05" wrote:

I have a spreadsheet with numbers in 2 different colours in each column. Is
there a formula I can use to total only numbers in one colour?