Countif (Archiv:Archiv; 0)
my sheet summary currently counts 49 hotels when I set the filter "Archiv=0".
It should be 39.
I guess the reason are the blank rows under the filled rows. But I cannot delete them.
Every time I delete the rows and save the entry, then setting the filter, the blank rows appear again.
Any idea what makes the magic ;-)
Help Article Resources
Check out the Formula Handbook template!