Does anyone know how to count the number of unstarred boxes without adding in the blank rows?

edited 02/23/24 in Formulas and Functions

Every time I try to count the number of boxes that aren't starred it counts the rows that are blank as well. How do I only include the rows that are not starred and aren't blank.

This is the original formula I used but it is included all rows.

=COUNTIF({2024 USPS Audit Failures and Exceptions Range 3}, "0")


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!