Count Blanks in a Filtered Column
Assuming that the secret column range is B5:B200...
=SUMPRODUCT(SUBTOTAL(3,OFFSET(B5:B200,ROW(B5:B200)-ROW(B5)),,1)),--(B5:B200=""))
Gos-C wrote:
Hi,
Is there a function to count blanks in a filtered column? That is, if
I filter a column to show the rows that are blank, can I use the
subtotal function (or some other) to count the number of blanks?
Thanks,
Gos-C
|