Use the COUNTIF function in Microsoft Excel
Posted on: 12/28/2016
The Countif function in Microsoft Excel is one of the most popular functions in Excel you can easily master. I use Countif to figure out how many employees are in a certain state or how many customers placed an order for $100 or over. You can even use wildcards in the Countif function.
I would place the Countif function in the top 10 Excel functions to know. The countif function has two arguments. The range and the criteria. =Countif(B2:B50,”Atlanta”) would look in the range B2 through B50 for the word Atlanta. The criteria, if text, must be placed in quotation marks. The criteria is not case sensitive. So if you are trying to find out how many people are in Atlanta, you can put in Atlanta as aTLaNta, or ATLANTA, or AtlANta, etc…
COUNTIF Excel file
Click to download the Excel file used in the video below. Countif functions are already created.
YouTube video on Countif by Chris Menard
Helpful links on Countif Function
Chris Menard
Chris Menard is a Microsoft Trainer (MCT) and works as a full-time Trainer at BakerHostetler - one of the largest law firms in the US. Chris runs a YouTube channel with 900+ technology videos that cover various tools such as Excel, Word, Zoom, Teams, Gmail, Copilot, Google Calendar, and Outlook. To date, the channel has helped over 20 million viewers.
Menard also does 2 to 3 public speaking events yearly, presenting at the Administrative Professional Conference (APC), the EA Ignite Conference, the University of Georgia, and CPA conferences. You can connect with him on LinkedIn at https://chrismenardtraining.com/linkedin or watch his videos on YouTube at https://chrismenardtraining.com/youtube.
Categories