• 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

    Hui...

  • 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

jsk_lge

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?
 

jsk_lge

New Member
@Narayan
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:

Hui

Excel Ninja
Staff member
=SUMPRODUCT(SUBTOTAL(103,OFFSET(A2,ROW(A2:A100)-ROW(A2),0)),(A2:A100="d")+0)
Adjust Column A and 100 to suit your data
 
Top