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
-
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},''')
Answers
-
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},''')
-
Thank you David that solved my problem!
-
Awesome! Glad it is working.
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.5K Get Help
- 430 Global Discussions
- 136 Industry Talk
- 465 Announcements
- 4.9K Ideas & Feature Requests
- 143 Brandfolder
- 146 Just for fun
- 63 Community Job Board
- 466 Show & Tell
- 32 Member Spotlight
- 2 SmartStories
- 298 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!