Posted to microsoft.public.excel.programming

Sean[_7_]

external usenet poster

Posts: 20

Count Visible

I have a spreadsheet with autofilters. I would like the
count of visible data to change with the filters. Is there
a way to do this like subtotal(9,data)?

Thanks for the assist.

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
Count of visible, non-blank cells only?	Alain Dekker[_2_]	Excel Discussion (Misc queries)	8	September 23rd 09 02:40 PM
How to keep Status count visible?	TotallyConfused	Excel Worksheet Functions	1	September 12th 08 06:55 PM
Count only visible cells	Joe M.	Excel Discussion (Misc queries)	4	July 26th 07 04:04 PM
count if on Visible - Filtered	tonyv	Excel Worksheet Functions	4	July 7th 07 07:34 PM
count only visible cells	bnkone	Excel Worksheet Functions	2	March 31st 06 01:39 AM

All times are GMT +1. The time now is 03:23 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us