Excel COUNTIF Condition Examples

A revised version of this content is now available at blog.officewizkid.com


Excel COUNTIF is one of these functions that are simple enough to understand the concept but make you scratch your head when you try to do something less trivial with the condition part.

Sure, simple cases are simple enough:

How to count all the cells in a range A1:A100 that have a specific value called “MyValue”:

=COUNTIF(A1:A100,"MyValue")

But how do you scale to more complex scenarios. E.g. How do you calculate COUNTIF with a condition that references another cell?

Here is a very nice blog with multiple examples reviewing the hidden potential of the COUNTIF function.

How to use Excel COUNTIFS and COUNTIF with multiple criteria

Advertisements

Author: dave

Consider myself kid in soul and naive by choice. I am interested in people, technology and business and thrive when they all work together. My favorite quote and motto is that “You can fool some people some times but you cant fool all the people all the time” ― Bob Marley

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s