Don't Count if Cell is Bank

Kimberlee Adam

Hi All,

I am using a checkbox formula to count the status of a task. Is there a way to also include to not include blank cells in the count?

My formula is =IF([1 Rough Draft Writing Status]11 = "Not Started", 1, 0)

I want to drag the formula down but I also have rows that don't have anything in the status column because I'm using them as row headings.

Thank you,

Kim

Paul Newcome

There are a couple of ways to do this. Which column would the blank cells be in?

 

To include it in the checkbox column, you would use something along the lines of

 

=IF(AND([Column Name]@row <> "", [1 Rough Draft Writing Status]11 = "Not Started"), 1, 0)

 

or you can just include it in your formula used to pull the count of checked boxes.

 

=COUNTIFS([Check Column]:[Check Column], 1, [Column Name]:[Column Name], @cell <> "")