subtotal blank cells

[The Rook]

I am wanting to count blank cells when using filters. I have tried
=subtotal(9,=countblank(A1:A500)) but it will not accept this formula.

Is there anyway I can do this?

 

[Pete_UK]

Fill a helper column with 1 in every cell, and then you can use this
as a count:

=SUBTOTAL(9,helper_range)

This will give you the count of the filtered (visible) items.

Hope this helps.

Pete

 

[Gord Dibben]

Why use the subtotal function?

Wouldn't =COUNTIF(A1:A500,"") do the same thing?


Gord Dibben MS Excel MVP