How to COUNTIF # results of advanced filter


Posted by Tim McPike on January 19, 2001 11:07 AM

I want a cell to display the number of items resulting from an advanced filter. Do I use COUNTIF ? What are the conditions? Or another function?

Thanks for any help.



Posted by Mark W. on January 19, 2001 11:51 AM

Use SUBTOTAL(2,ref) where "ref" is a valid cell
reference.