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
Check out the Formula Handbook template!