There are a few ways to count the number of items in an Excel list, depending on the data you have. In this tutorial, learn how to count items in Excel using the COUNTIF and SUBTOTAL functions.

Other Excel tutorials and resources Overall, the COUNTIF () function is fairly simple to use — it’s the condition expressed in criteria that might cause confusion.

Need to find cells with specific text? The COUNTIF formula in Excel has got you covered.

Learn how to count blank or empty cells in Excel and Google Sheets. Use COUNTBLANK , COUNTIF or SUMPRODUCT function to count blank cells in spreadsheet.

Note that the content that follows is based on Microsoft Excel 365 for PCs. Other versions of Excel may work differently. Let’s look at some examples of how to use COUNTIF and COUNTIFS. First, let’s ...

How to Create a Word Phrase Count in Excel. Excel is a powerful tool in the Microsoft Office suite of programs that allows you to create spreadsheets that can present a simple set of information ...

When analyzing grades (especially for a large class) the COUNTIF function in Excel can be extremely helpful. For example, suppose you have entered your final letter grades, and you need to report how ...