• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User


  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Countif in a filtered list


New Member
I have a filtered list contains letters a, b, c, d etc.
i want to count those cells only which contains "d".
which function should i use?


New Member
dear Sir,
I cant understand how to apply countif in subtotal ?

like =subtotal(2,?,?,?,...)
which function no. should i use and how apply the condition??
Last edited:


Excel Ninja
Staff member
Adjust Column A and 100 to suit your data