COUNTIFS reference other cell, count cells with BLANK value in a column, part of formula works

Aparna Singh
Aparna Singh ✭✭✭
edited 05/03/22 in Formulas and Functions

I want to count how many cells are blank after they meet the range 1 and range 2 criteria. The formula works without the last part which is count blank cells. When I add the last part to the formula, it gives me #UNPARSEABLE error. What am I doing wrong?

=COUNTIFS({Range1}, "xyz", {Range2}, "abcd", {Range3}, <>"")

=COUNTIFS({Range1}, "xyz", {Range2}, "abcd", {Range3}, ISBLANK@cell)



Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!