Need a number count of items on list after Filterings
 

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

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
__________________________

Need a number count of items on list after Filterings
 

I want Microsoft to make this feature automatic. If not then I will carry on
as I have. Place the number 1 in the top cell of a blank column of the list,
point to the lower corner of that top cell to activate Autofill and hold down
left mouse and drag the Autofill down the column to the end of the list. Sum
the list and voila! Taylor

"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

Need a number count of items on list after Filterings
 

Are you using the Autofilter? Not sure about XL2003, but XL2000 shows a
message in the status bar (lower left) showing the number of records found
and Total number of records after performing a filter operation.


"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

Need a number count of items on list after Filterings
 

=SUBTOTAL(function_num,ref1,ref2,...)
Refer to the help

Subtotal works with filtered lists
from the help file function_num can be the following
1 AVERAGE
2 COUNT
3 COUNTA
4 MAX
5 MIN
6 PRODUCT
7 STDEV
8 STDEVP
9 SUM
10 VAR
11 VARP

In your case you need 2 for count
Hope it helps

George

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

Need a number count of items on list after Filterings
 

Select the range of interest. Run Data|List|Create List. This provides
the AutoFilter functionality automatically. Activate the Total row to
obtain the automatic count you desire.

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