Using Subtotal with countifs

[rishilaughs]

Content	Category
Random Content 1	A
Random Content 2	B
Random Content 3	A
Random Content 4	B
Random Content 6	B

<tbody>
</tbody>

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.