If you find yourself in a situation where you need to get a count of cells that contain one or more criteria, Excel includes both the COUNTIF and COUNTIFS functions for you to use.

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 ...

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

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 ...

There are two ways to calculate a conditional average in Excel, both involve some logic and some special functions.