Count if the cell in two different columns is blank

Stephanie Foster

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},'''))

David Tutwiler

Rather than use COLLECT and COUNT I think you can do this with COUNTIFS:

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

David Tutwiler

Rather than use COLLECT and COUNT I think you can do this with COUNTIFS:

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

Stephanie Foster

Thank you David that solved my problem!

David Tutwiler

Awesome! Glad it is working.