Can COUNTIF exclude hidden cells

[xaser]

Hi Folks,

I'm hoping this will be an easy one. I am simply trying to count blank cells in a column but I would like to exclude the hidden rows if possible.

The formula I'm using is =COUNTIF(E3:E63,""), very basic but it's picking up the hidden rows.

Any help would be greatly appreciated.

 

[MarcelBeug]

I don't think this can be done directly, but a workaround would be to create a helper column, let's say Z, with Z3 =--(E3="") copy down through Z63.
This will give you a 1 if E is "" and 0 if not.
Next: =SUBTOTAL(109,Z3:Z63).
This will sum the values in Z3:Z63, excluding hidden rows.

 

[smallxyz]

deleted...

 

[xaser]

Thanks MarcelBeug that did work. Very complicated for something so simple.

 

[MarcelBeug]

Thanks MarcelBeug that did work. Very complicated for something so simple.

You're welcome. Otherwise this was by far not the most complicated solution I provided on this forum.