Using Subtotal with countifs

[rishilaughs]

[TABLE="width: 500"]
<tbody>[TR]
[TD]Content[/TD]
[TD]Category[/TD]
[/TR]
[TR]
[TD]Random Content 1[/TD]
[TD]A[/TD]
[/TR]
[TR]
[TD]Random Content 2[/TD]
[TD]B[/TD]
[/TR]
[TR]
[TD]Random Content 3[/TD]
[TD]A[/TD]
[/TR]
[TR]
[TD]Random Content 4[/TD]
[TD]B[/TD]
[/TR]
[TR]
[TD]Random Content 6[/TD]
[TD]B[/TD]
[/TR]
</tbody>[/TABLE]

Dear,

I know this type of question has been addressed before but I was having problem understanding the multiple formulae used and how it could be applied to my specific problem.

What i am trying to do is, use Subtotal function in conjunction with Countif

For the given problem, please guide how to count(CountA) category (either A, B,C) in a filtered row using formulae.

I am using http://www.mrexcel.com/forum/excel-questions/698211-combine-countif-subtotal.html this as reference but having problem understanding so many nested formulae.

Thanks

 

[yanivp1]

Thank you very much, it works. I appreciate it so much!

 

[Aladin Akyurek]

Thank you very much, it works. I appreciate it so much!

You are welcome.