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

--
HTH

Bob Phillips

"24 Jan 05" wrote in message
...
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?