Subtotal Countif

[Alberto Ast]

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?

 

[eksh]

Hello Alberto,

what is the reason to use subtotal? this formula will ignore hidden and
filtered rows. is it possible to use sum(A5:A200)?

 

[T. Valko]

Is there an option to countif( ) those cells

after being filter as above?

It can be done. What column do you want to perform the "countif" on and
what's the criteria?

 

[Alberto Ast]

I need to count the rows left after the filtering of some rows... when I need
to add non filtered data I use subtotal... but it only adds up... need a
similar that will count not add.

 

[Alberto Ast]

I need to count the rows left on Column A after filtering some dates out.

 

[Domenic]

Try...

=SUBTOTAL(3,A5:A200)

....which will count the number of visible rows in A5:A200 containing
data.

 

[Alberto Ast]

Thanks, this is what I needed.... thanks.

Try...

=SUBTOTAL(3,A5:A200)

....which will count the number of visible rows in A5:A200 containing
data.

--
Domenic
Microsoft Excel MVP
www.xl-central.com
Your Quick Reference to Excel Solutions

 

[mwjmk]

Hi,

What do we do if we need to count rows based on their values, instead of whether they are not empty? I need to count the number cells in the column that are not hidden, and contain "yes", versus "no". For example. need to =Subtotal(countif(A2:A10, "yes")). But there is no Subtotal option for countif. Countif by itself obviously counts hidden cells. Anyone tell me if this is available in Office 2010, as I have Office 2007.