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