How to add numbers in a column dependant on their colour

[Guest]

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?

 

[Bob Phillips]

See http://www.xldynamic.com/source/xld.ColourCounter.html, but note the
constraints

 

[Guest]

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