Count blanks cells in a filtered range


Assume data in range A3:D8 (headings are in A3:D3).  One may apply an auto filter on any column(s).  The task is to count the blank cells in visible rows of range C4:C8 and D4:D8.

You may refer to the data set and my solution in this workbook.

Leave a Comment

Your email address will not be published.