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

How to count blank cells in filtered condition

A

Arup Dutta Chowdhury

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

Attachments

  • Book11111.xlsx
    11.3 KB · Views: 4
Arup Dutta Chowdhury said:
In my excel sheet some names and their contact number is given. I want to know if I filter any name then what is the count of total blank cells showing against that particular name. For Example if I filter and select LP then I want to know how many blank cells LP has got. I have used countblank formula but it is not working in filtered condition. Please help me on urgent basis.
Click to expand...
Hi,

Try this

=SUBTOTAL(3, $A$1:$A$52) - SUBTOTAL(3, $B$1:$B$52)
 
Thanks for the reply but i want to know for a particular name how many blank cells are there. For example if I filter and select LP then how many blank cells LP has got I want to know that .
 
Arup Dutta Chowdhury said:
Thanks for the reply but i want to know for a particular name how many blank cells are there. For example if I filter and select LP then how many blank cells LP has got I want to know that .
Click to expand...
Hi,

That's exactly what my formula does. have a look at your workbook attached here.
 

Attachments

  • Book11111.xlsx
    12.5 KB · Views: 6
Dear Arup , Sorry to interrupt , But formula mentioned by Mike works on different sheets of the same workbook as well. Only change you need to do is to append sheet name in you reference.

i.e. =SUBTOTAL(3,Sheet1!$A$2:$A$54)-SUBTOTAL(3,Sheet1!$B$2:$B$54)
 
You must log in or register to reply here.
Back
Top