Thread: COUNTIF
View Single Post
  #2   Report Post  
Anne Troy
 
Posts: n/a
Default

=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?