MS Excel COUNTIF
Posted on 2013-06-05
I am trying to work with a COUNTIF but I am trying to set a range that will include future data. Unfortunately, I cannot seem to find how to exclude blank cells. Here is what I'm doing.
I want to count all instances that do not include an order status of Cancelled. Therefore I am using the following formula.
Currently I only have 10 rows of data with 3 including the word cancelled. I should have a count of 7 but I am getting a count of 196.
How do I exclude the empty rows? I do not want to need to modify the formula every time additional data is added.