Using The Excel Count Function

Excel function tutorials

If you want to learn Excel, keep reading or Get 10 days of free unlimited access to for professional help and Excel Tutorials

One of the more simple but recurring tasks in excel is trying to determine how many cells in a given range result in a given answer, which could be a number, or any other symbol. There are many different ways to get that result in excel but I personally think the “countif” function is the most efficient way of getting it done.

Suppose that you have a spreadsheet with a number of different columns and you’re trying to determine how many of the stocks in this spreadsheet in column “D” have “US” as their country of incorporation, I could do the following:

You would see that 473 of the 500 names

Simple enough? I would hope so! As always you can download the spreadsheet here


Look Good at Work and Become Indispensable Become an Excel Pro and Impress Your Boss



Please Leave a Comment!

Please note: Comments may be moderated. It may take a while for them to show on the page.