Alex

If you're already using AutoFilter, you can probably use this version
of the SUBTOTAL function:

With a data list in Cells A5:A1000

A2: =SUBTOTAL(3,A5:A1000)-1
The minus 1 is to remove the Header count.

After filtering, the formula will return the count of the un-hidden
records.


Other options for the first argument of the the SUBTOTAL function:
Function_Num Function
1 AVERAGE
2 COUNT
3 COUNTA
4 MAX
5 MIN
6 PRODUCT
7 STDEV
8 STDEVP
9 SUM
10 VAR
11 VARP

Does that help?

Regards,
Ron


--
Ron Coderre
------------------------------------------------------------------------
Ron Coderre's Profile: http://www.excelforum.com/member.php...o&userid=21419
View this thread: http://www.excelforum.com/showthread...hreadid=507326