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?

Subtotal Countif
 

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)?

"Alberto Ast" wrote:

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?

Subtotal Countif
 

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?


--
Biff
Microsoft Excel MVP


"Alberto Ast" wrote in message
...
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?

Subtotal Countif
 

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.

"eksh" wrote:

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)?

"Alberto Ast" wrote:

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?

Subtotal Countif
 

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

"T. Valko" wrote:

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?


--
Biff
Microsoft Excel MVP


"Alberto Ast" wrote in message
...
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?

Subtotal Countif
 

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

In article ,
Alberto Ast wrote:

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

"T. Valko" wrote:

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?


--
Biff
Microsoft Excel MVP


"Alberto Ast" wrote in message
...
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?

Subtotal Countif
 

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

"Domenic" wrote:

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

In article ,
Alberto Ast wrote:

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

"T. Valko" wrote:

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?


--
Biff
Microsoft Excel MVP


"Alberto Ast" wrote in message
...
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?