How to countblank in two different columns

Trying to utilize this function but is not working

Answers

  • Katie G
    Katie G ✭✭✭✭

    It looks like you have an extra parentheses between the first range+criterion and the second one... try removing that? My instinct would also be to use ISBLANK to get a true/false value instead of IFBLANK.

    E.g., =COUNTIFS({Range 1}, ISBLANK(@cell), {Range 2}, ISBLANK(@cell))

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!