If you have Excel 2002 or later, then you can use this:

=SUBTOTAL(103,A1:A100)

Hope this helps.

Pete

On Dec 10, 6:12*pm, CEG_Staffer
wrote:
I have a worksheet that I would like to be able to count only the displayed
cells in a column i.e. I do not want to count hidden cells (rows). If all
rows are displayed the total count should equal all rows with contents
(counta function), if not - count only those rows displayed.