Hi Kyara

this is not possible without using VBA ... see
http://www.cpearson.com/excel/SortByColor.htm for details.

--
Cheers
JulieD
check out www.hcts.net.au/tipsandtricks.htm
....well i'm working on it anyway
"KyaraB" wrote in message
...
I need to total a range of cells in excel based on the font color. I assume
this would be done with an "IF" statement but how do I word it?
I want to total cell range C8 to AG8 but only if the font color is Blue.