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!