Stop counting blank cells
I have a column of checkboxes. Currently there are 16 rows with data but 18 rows total. I have a column setup for some of these called Skip which checks a box off so another function will know to skip those (Currently two rows are being skipped which is giving a count of 16). However when I want to count the blank checkboxes in a column instead of counting 16 it is counting 18 and and skipping the two so I am getting a result of 16 when really i should be getting a count of 14. Two blank rows are below the boxes. If I delete those i get an accurate count, Whenever I check off a box it adds the two blank rows back in and counts them again. Is there anyway to stop this?
Current formula: =COUNTIFS(Skip:Skip, 0, Activated:Activated, 0) - This is giving me 16 when it should give 14 because of my skip column
Best Answer
-
Chris,
Try adding a helper column and add this formula.
=IF(Skip@row = "", "", IF(Skip@row = 1, 1, 0))
Answers
-
Chris,
Try adding a helper column and add this formula.
=IF(Skip@row = "", "", IF(Skip@row = 1, 1, 0))
-
That worked once I changed from the Skip column to the Helper column in my formula.
Thank you!
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.9K Get Help
- 441 Global Discussions
- 139 Industry Talk
- 472 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!
