• 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.

Count cells containing numbers in filtered option

A

Arup Dutta Chowdhury

Member
In my excel sheet some names and their contact number is given. I want to know if filter any name then what is the count of contact numbers showing against that particular name.For Example if i filter and select LP then i want to know how many contact numbers LP has got. I have used count and subtotal formula but it is not working in filtered condition. Please help me on urgent basis.
 

Attachments

Dear Swapnil i don't want to use subtotal formula as i have to put the result in other excel sheet. Also subtotal formula will not work as if i select another name the result will not come up. Subtotal formula work on the same sheet but i want put the answer in another sheet. Please help.
 
did you append the workbook name , sheet name while using formula in other worksheet???

I mean you should use.

=SUMPRODUCT(([Book11111.xlsx]Sheet1!$A$2:$A$54=Name you want to count for)*([Book11111.xlsx]Sheet1!$B$2:$B$54<>""))
 
Have put the formula in sheet 2 of your workbook. The same formula works for me .... Select name in cell G2...It'll give count in H2.
 

Attachments

You must log in or register to reply here.
Back
Top