Subtotal Countif

  • Thread starter Thread starter Alberto Ast
  • Start date Start date
A

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?
 
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)?
 
Is there an option to countif( ) those cells
after being filter as above?
Click to expand...

It can be done. What column do you want to perform the "countif" on and
what's the criteria?
 
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.
 
Try...

=SUBTOTAL(3,A5:A200)

....which will count the number of visible rows in A5:A200 containing
data.
 
Thanks, this is what I needed.... thanks.

Domenic said:
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
Click to expand...
 
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.
 
Back
Top