Using COUNTIFS to Compare one Column for Blanks and One for Data
Sinema
✭✭
Greetings
=IF(AND(NOT(ISBLANK({Date In Service})), {In Service Zones}, Zones1))
I'm trying to compare one column that shows install dates and one that has an actually name in it.
Is that possible?
Comments
-
you want to count how many have blanks for the date for service zone 1?
=countifs({Date in service column reference}, not(isblank(@cell)), {In Service Zones}, Zones1)
Something like that should work. Make sure to double check your column references to be sure they contain actually are referencing the columns. Often users will click off without realizing it, then their formulas don't work even if they are perfectly typed.
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