How to countblank in two different columns

tmagana
tmagana ✭✭
in Formulas and Functions
image.png

Trying to utilize this function but is not working

· Share on FacebookShare on Twitter

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))

    · Share on FacebookShare on Twitter

Help Article Resources

Create and edit formulas in Smartsheet

Formula combinations for cross sheet references

Smartsheet functions list

Categories

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!