Count Blanks in a Filtered Column
That doesn't work. Result = 0, unfiltered or filtered. I tried that formula
(along with many other variations) earlier.
Typo in the formula, one too many ")"
ROW(B5)),,1))
ROW(B5),,1))
Biff
"Aladin Akyurek" wrote in message
...
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
|