If you are not using the filter, what is wrong with using the countblank
function?
"GaryE" wrote:
No need to filter it first just use the following where "range" contains
the range of cells with blank numbers
=SUM(IF(ISBLANK(range),1,0))
just make sure you use control-shift-enter to enter the formula because
this is an array formula.
This checks to see if a cell is blank if it is it adds 1 to the total.
HTH,
Gary
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
--
Gos-C
------------------------------------------------------------------------
Gos-C's Profile:
http://www.***************/member.ph...o&userid=14518
View this thread:
http://www.***************/showthrea...hreadid=524428
--
GaryE
Posted from - http://www.officehelp.in