LinkBack URL
About LinkBacks
is there a way i can count blank cells in a filtered list?
is there a way i can count blank cells in a filtered list?
You can check the difference between a Subtotal/COUNTA of the column you filtered and the column you're checking for blanks.
=SUBTOTAL(103, $A$3:$A$12) - SUBTOTAL(103, $B$3:$B$12)
_________________
Microsoft MVP 2010 - Excel
Visit: Jerry Beaucaire's Excel Files & Macros
If you've been given good help, use theicon below to give reputation feedback, it is appreciated.
Always put your code between code tags. [CODE] your code here [/CODE]
?None of us is as good as all of us? - Ray Kroc
?Actually, I *am* a rocket scientist.? - JB (little ones count!)
1st & Best method (from the previous commentator-admin)
=subtotal(103, $a$3:$a$12) - subtotal(103, $b$3:$b$12)
or
2nd method (my method)
=sumproduct(subtotal(3,offset(a3:a12,row(a3:a12)-min(row(a3:a12)),,1)),--(a3:a12<>""))-(sumproduct(subtotal(3,offset(b3:b12,row(b3:b12)-min(row(b3:b12)),,1)),--(b3:b12<>"")))
In both method, Column A should not have any blank cells..
(But I am still not satisfied with this methods of using another column to aid this calculation...) I am waiting for some better answer...
Last edited by sajumgeorge; 05-28-2013 at 02:01 AM.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks