Posted to microsoft.public.excel.misc

Alberto Ast[_2_] Alberto Ast[_2_] is offline

external usenet poster

Posts: 181

Subtotal Countif

If I have a filter on column "A..G" and then I filter on ecolumn for x
criteria... I do subtotal (9,A5:A200) it will only add up those meetting the
filter criteria...

Is there an option to countif( ) those cells after being filter as above?

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
countif & subtotal functions	sot	Excel Worksheet Functions	3	May 29th 08 05:49 PM
COUNTIF & SUBTOTAL	Dickie Worton	Excel Worksheet Functions	2	October 31st 07 10:26 AM
but < subtotal (3,...) or countif	PAR	Excel Worksheet Functions	3	April 22nd 06 10:48 AM
COUNTIF Subtotal Function?	jcpotwor	Excel Discussion (Misc queries)	2	January 12th 06 01:56 PM
Subtotal And Countif	Sheryl	Excel Discussion (Misc queries)	4	December 9th 04 07:18 PM

All times are GMT +1. The time now is 01:59 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us