Look in the help index for SUBTOTAL

--

Don Guillett

Microsoft MVP Excel

SalesAid Software

http://www.pcreview.co.uk/forums/(E-Mail Removed)
"PeterM" <(E-Mail Removed)> wrote in message

news:(E-Mail Removed)...

> Is there a way in Excel 2003 to use one of the count functions on a sheet

> that is using data filters. If I filter a column so that, for example, 10

> rows out of a total of 100 rows are currently displayed, to use a counta

> or

> countif function to count the rows filtered? In other words, I want the

> count function to return 10, not 100...thanks in advance for your help!