If you have Excel 2007 you can filter on colour then use the subtotal
function to sum the visible cells, In previous versions you need to roll
your own function

http://www.cpearson.com/excel/colors.htm



Regards,


Peo Sjoblom


"Help" wrote in message
...
Is there a way to do a =sum formula using font colors to include or
exclude
in the formula?