COUNTIF Formula
I am trying to create a countif formula to give me a count at the top of my column of how many empty rows in a shelf I have. If certain spaces in the shelf are empty they are labeled in my column as "EMPTY". I have tried this formula: =COUNTIF([Study Number]1:[Study Number]636, = "empty") but am having no luck. Please help!
Best Answer
-
Miranda,
When doing a COUNTIF formula you do not need to put the = sign in the criterion section. Also, unless your range needs to end at row 636 I would adjust the range to include the entire column. Try the formula below:
=COUNTIF([Study Number]:[Study Number],"EMPTY")
If you need it to end on row 636:
=COUNTIF([Study Number]1:[Study Number]636,"EMPTY")
Answers
-
Are you able to provide a screenshot for reference?
-
Miranda,
When doing a COUNTIF formula you do not need to put the = sign in the criterion section. Also, unless your range needs to end at row 636 I would adjust the range to include the entire column. Try the formula below:
=COUNTIF([Study Number]:[Study Number],"EMPTY")
If you need it to end on row 636:
=COUNTIF([Study Number]1:[Study Number]636,"EMPTY")
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63.8K Get Help
- 410 Global Discussions
- 219 Industry Talk
- 457 Announcements
- 4.7K Ideas & Feature Requests
- 142 Brandfolder
- 136 Just for fun
- 57 Community Job Board
- 459 Show & Tell
- 31 Member Spotlight
- 1 SmartStories
- 297 Events
- 37 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!