How can I count items in a filtered list?

Counting filtered data.

Posts: n/a

How can I count items in a filtered list?

I have an excel spread sheet table that I filter. I would like to be able to
count the number of cells in the filtered data. Anyone know how to do this?
CountA returns the number of cells in the unfiltered data.
Tom

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
named range, data validation: list non-selected items, and new added items	KR	Excel Discussion (Misc queries)	1	June 24th 05 05:21 AM
Count Position of Filtered TEXT cells in a column	Sam via OfficeKB.com	Excel Worksheet Functions	8	May 18th 05 04:23 AM
Count Position of Filtered TEXT cells in a column	Sam via OfficeKB.com	Excel Worksheet Functions	0	May 15th 05 08:14 PM
Items in a List	jcliquidtension	Excel Discussion (Misc queries)	1	April 5th 05 10:23 PM
How do I find out what items are in one list but not in another l.	Michelle Craig	Excel Discussion (Misc queries)	2	December 22nd 04 08:32 PM

All times are GMT +1. The time now is 06:45 PM.

Menu

About Us