Software & Apps MS Office How to Use the COUNTIF Function in Excel Get Excel to do the heavy counting work for you with this function By Jon Martindale Writer Jon Martindale has been a feature tech writer for more than 10 years. He's written for publications such as Digital Trends, KitGuru, and ITProPortal. our editorial process Facebook Twitter LinkedIn Jon Martindale Updated February 28, 2020 MS Office Excel Word Powerpoint Outlook Tweet Share Email Knowing a few Excel tips and tricks can make a world of different in your personal and professional life. From balancing your household budget to organizing sales reports, Excel is an awesome tool for getting to grips with the numbers in your life, and the COUNTIF function is one of its best tools. Here's how to use the COUNTIF function in Excel. The instructions in this article apply to Excel in Office 365, Excel 2019, and Excel 2016. What is the COUNTIF Function? Excel is an excellent tool when it's manually controlled, but it's even better when you can automate parts of it. That's where functions come in. From adding numbers together with SUM to removing non-printable characters with CLEAN. COUNTIF works in much the same way, but its job is to count the number of cells that match a certain criteria. It can be used to count cells that have certain figures in them, certain dates, text, special characters, or anything else you want to differentiate them with. It takes inputs and spits out a total number depending on your chosen criteria. How to Use The COUNTIF Function in Excel The COUNTIF function can be input manually or using Excel's Formulas menu. In either case, the eventual formula will look something like: =COUNTIF(D4:D10,"Yes") In this COUNTIF example, the function would search through cells D4 through D10 looking for the word 'Yes.' It would then output a number of how many times it finds it in the cell you input the formula in. You can write this in manually if you prefer, but an easier method is to use Excel's Function menu. Open the Excel document that you want to use the COUNTIF function in and make sure all of the data you want to use is present and correct. Select a cell where you want the COUNTIF function results to appear. Select the Function fx logo in the top-left of the main Windows, next to the cross and tick marks. Use the dropdown menu to select All, then in the search box, type COUNTIF. Select the corresponding result and select OK. As you're selecting this function, make sure to select COUNTIF, rather than COUNTIFS. COUNTIF uses a single criteria where COUNTIFS uses multiple criteria. In the Function Arguments window that appears, either type in the Range (the beginning and end, separated by a colon) or click/tap and drag through the cells you want to be considered in the calculation. In our COUNTIF example, that's cell D4 through D10, so it's input as D4:D10. You can use a question mark to match with any one character and an asterisk matches any sequence of characters. Type or select the Criteria that you want COUNTIF to count. In our example, we want to know how many Yes results are in the D column, so we input Yes. These steps can be repeated for the No responses, ultimately learning there were two No results in the list of responses. The COUNTIF function can be used on a near infinite amount of data, and the larger that dataset is, the more useful COUNTIF can be. Select OK. If you input everything correctly, you should see the result appear in the cell you performed the COUNTIF function in. In this example, the result of 5 appeared. If you want to look for results in multiple ranges simultaneously, you can do so, but you'll need to use the COUNTIFS function instead.