Try this working sample from my archives**:
http://www.savefile.com/files/377039
CountCellsByFillColor_Using_BobPhillips_ColorIndex _UDF.xls
(Full details & beautifully rendered ..)

**link in sign-off below
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"HANYANA" <u30570@uwe wrote in message news:6b86575e611de@uwe...
Hi there,
i have been trying to get the Color Index summing formula to work but i am
unsuccessful, i went onto this site
http://www.xldynamic.com/source/xld....r.html#summing but have
gotten no where for some reason the formula will not work and i am left
scratching my head again. If anyone can help i would really appreciate it
as
i have come to a complete standstill with my roster.
Thanks
Hanyana