Count if the cell in two different columns is blank

I am trying to do a conditional count if 2 columns from the same spreadsheet is blank. Here is the formula I am using that is coming up with an error message. With Column 1 being CT BAY and Column 2 Being Range Baylor. In other word if both these columns are blank then to count it. This is the formula I am using am I doing something wrong?

=COUNT(COLLECT({Pipeline Report (FRFD)_09.28.2020 Range CT BAY1},"",{Pipeline Report (FRFD)_09.28.2020 Range Baylor},'''))

Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!