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
- 65.5K Get Help
- 448 Global Discussions
- 145 Industry Talk
- 481 Announcements
- 5.1K Ideas & Feature Requests
- 85 Brandfolder
- 152 Just for fun
- 73 Community Job Board
- 492 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 304 Events
- 37 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!
