View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Susan Susan is offline
external usenet poster
 
Posts: 1,117
Default =counta() unless row is hidden

hi all
in column A i have some text data. some of the rows have been
hidden. i want to count how many are left (visible). but any COUNT
functions count the hidden rows, too. any ideas?
thanks a lot in advance.
susan