View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Richard Buttrey
 
Posts: n/a
Default Need a number count of items on list after Filterings

On Mon, 20 Mar 2006 15:16:28 -0800, Taylor
wrote:

I am using Excel 2003 to manage a Club list and would like an automatic
number count of the names on my list both before and after using various
Filter functions.

----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.

http://www.microsoft.com/office/comm...et.f unctions



Before is just

=COUNTA(A10:A20)

After is

=SUBTOTAL(2,A10:A20)

where A10:A20 is the column range which includes all the rows of your
data.

HTH
__
Richard Buttrey
Grappenhall, Cheshire, UK
__________________________