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.9K Get Help
- 441 Global Discussions
- 139 Industry Talk
- 471 Announcements
- 4.9K Ideas & Feature Requests
- 129 Brandfolder
- 148 Just for fun
- 68 Community Job Board
- 496 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 300 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!