Hi ,
I want to count number of checked check boxes after applying filter on Name field. Issue is i used countif function but it showing the result of all checked inboxes but i need only filtered cells checked check boxes count. Need Help
Thanks,
Faizan
you will need a helper column to do this.
if your checkboxes are in the range A2:A, and column C is empty, then you can put this helper into C2:
then to get your count of filtered and checked items, put this wherever you need the count:
Please Login or Register to view this content.
Please Login or Register to view this content.
As a gesture off appreciation, you can click * Add Reputation at the foot of any of the posts of members who helped you reach a solution.
And finally, was your problem solved? if so, please click Thread Tools above the first post of your enquiry, then select [Solved]
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks