rishilaughs
New Member
- Joined
- Jun 10, 2013
- Messages
- 6
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