Need to calculate the number of Filtered rows

[Paul]

I have a spreadsheet that I have activated a filter, I
need to count the number of rows that the filer returned

 

[RagDyeR]

Subtotal() works well on filtered lists.

Try:

=SUBTOTAL(3,A1:A100)

Look in Help for all the other function options.
--

HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================

I have a spreadsheet that I have activated a filter, I
need to count the number of rows that the filer returned

 

[Don Guillett]

Have a look in HELP index for SUBTOTAL

 

[DDM]

Paul, assuming your UNfiltered data is in A1:A100, this will count the
number of rows a filter returns =SUBTOTAL(2,A1:A100).

The 2 tells the SUBTOTAL worksheet function to count the rows. When you have
time, search "SUBTOTAL Worksheet Function" in Excel help for your version.
Microsoft has introduced some enhancements to this function in Excel 2003.

 

[Frank Kabel]

Hi
try
=SUBTOTAL(3,A1:A1000)

 

[DDM]

....and I'm making the assumption that your column label (which you don't
want to count) is in A1.