Subtotal with condition

If you are looking for subtotal after filter then try this :

Formula:

=SUBTOTAL(3,A$2:A$11)

Or

Formula:

=SUBTOTAL(103,A$2:A$11)

And if you want count in a regular way then :

Formula:

COUNTIF(A$2:A$11,"A")

Hi All,

Thanks for your support.

But I think, the above solutions will now work for my issue.

Please find the attachment for your reference.
Capture.PNG

I am having a slicer for filtering Region. And after the filter, i need to see the count in that region against each name.

Thanks!

Regards,
Manoj