Thread: SubTotal function to return number of rows returns only zero
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
DZ DZ is offline
external usenet poster
  
Posts: 29
Default SubTotal function to return number of rows returns only zero
I am trying to use the SubTotal function to return number of rows as I
autofilter
--
It always returns zero no matter how many rows are visible.

=SUBTOTAL(2,A5:C200)

A5:C200 is the range including the column headings

Any ideas why this is not working

Thanks

Reply With QuoteReply With Quote