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?