MS Excel COUNTIF

Hello,

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.

=COUNTIF(E2:E200,"<>Cancelled")

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.

Thanks,

John
JohnAsked:
Who is Participating?

Improve company productivity with a Business Account.Sign Up

x
 
Saqib Husain, SyedConnect With a Mentor EngineerCommented:
Try

=COUNTIFS(E2:E200,"<>Cancelled",E2:E200,"<>")
0
 
JohnAuthor Commented:
Thanks! That was exactly what I needed!
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.