- Dec 2, 2015
I have the formula (Table1[Flat] is Column D)to count non-blank cells in a column. However, it is counting blank cells too. Every cell in the column including the blank ones contain the following formulaHence the blank cells contain "". The column is part of a table. I've tried to minus the blank cells from the SUBTOTAL after adding the blank cells of the table column with the COUNTBLANK function, but that doesn't hold when using filters. Any help appreciated.
I have the formula (Table1[Flat] is Column D)
=IF(ISBLANK(B3), "", IF(AND(B3 >= DATE(2016,3,3),B3 <= DATE(2016,6,12)), "No", "Yes"))