See http://xldynamic.com/source/xld.ColourCounter.html

--
__________________________________
HTH

Bob

"Dtemp" wrote in message
...
Is there a Way to use the SumIf formula to Sum the Cells of a Certain Text
Color. For example i would like the cells that have a text color of red in
a
certain column to be added up, and if the text of any other cell is that
column is changed to red it will automaticaly place it in the sum. If the
Sumif does not work is there another way i can use, i have little or no
progamming skills.