COUNTIF Formula

MirandaLang

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!

JCluff

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")

Paul Newcome

Are you able to provide a screenshot for reference?

JCluff

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")