View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
CEG_Staffer[_2_] CEG_Staffer[_2_] is offline
external usenet poster
 
Posts: 13
Default Counting only displayed cells in the column

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.