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.
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.
Count blanks cells in a filtered range
{ 0 Comments }