Basically, I need to count all of the rows in a filtered table regardless of if a cell has a value or not. SUBTOTAL(3,[my range]) will get me a count of all of the visible cells containing values. But, it omits blanks. And some fields may be blank in any given row of the dataset.
I need this to be completely formula driven if possible.
SubtotalSample111.xlsx
Bookmarks