2 is COUNT which counts only numerics.

Perhaps 3 which is COUNTA would be better.


Gord Dibben MS Excel MVP

On Wed, 16 Jan 2008 16:45:08 -0800, 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