Ignoring Blank Cells

Options

How do I make this formula ignore blank cells? I want it to total the percent of YES cells to NO in a range.

=COUNTIFS(CHILDREN(), OR(@cell = "YES", @cell = "No aplica")) / COUNTIFS(CHILDREN(), OR(@cell = "", @cell <> ""))

Tags:

Best Answer

  • Genevieve P.
    Genevieve P. Employee
    Answer ✓
    Options

    Hi @Alishia Topper,

    Try this:

    =COUNTIF(CHILDREN(), "YES") / COUNTIF(CHILDREN(), <> "")

    This will count how many children say "Yes" out of all the children that are not blank (or counting the total of both Yes and No). Is that what you're looking for?

    Here's some information on COUNTIF and on CHILDREN.

    Let me know if this works for you!

    Cheers,

    Genevieve

    Join us at Smartsheet ENGAGE 2024 🎉
    October 8 - 10, Seattle, WA | Register now

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!