Try =CountA(C2:C65536) or something like that, mahmon.
*******************
~Anne Troy
www.OfficeArticles.com
www.MyExpertsOnline.com
"mahmon" wrote in message
...
I have databse of products, one colum contains text values for the colours
these products are, red, green , blue, etc. what functinocan tell me how
many
colours are in the column? help please