Count Blanks in a Filtered Column
Biff wrote...
....
How would you count EMPTY cells? I haven't been able to figure it out.
....
Presumably you mean cells containing nothing. If there were another
column in the filtered table that always contained something, then
=SUBTOTAL(3,OtherColumn)-SUBTOTAL(3,GivenColumn)
would count the number of cells in GivenColumn that contain nothing. As
for cells that contain things that evaluate to "", counting them
requires udfs.
|