Hi DZ

some questions, otherwise it's hard to know what's wrong:

Does your range has data in it?
COUNT only counts non empty cells!
Why do you use a 3-Column-Range?
That will result in an odd count , unless you use only one column
per row!

Carlo

On Jan 17, 9:45*am, DZ wrote:
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