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

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!