=COUNTA(a1:a10)
*******************
~Anne Troy
www.OfficeArticles.com
www.MyExpertsOnline.com
"luvthavodka" wrote in message
...
I need to count how many cells in a column contain anything, hence not
counting blank ones.
=COUNTIF(range,criteria)
what would the criteria be?