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

How to Calculate T-Value From Mean & Standard Deviation in Excel. Calculate t-values in your Microsoft Excel spreadsheet by combining built-in functions with custom formulas. T-values, also known ...

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

A straight ranking result is easy using one of Microsoft Excel’s ranking functions. Calculating a conditional rank is even easier if you let an Excel PivotTable do all the work.

The article How to calculate conditional subtotals in an Excel revenue sheet uses simple expressions, a function, and a conditional format to display a daily balance in a revenue sheet.

Percentages aren't always easy to calculate, but one of the best tools in Excel's toolbox is calculating percentages for you. Here's how to do it.

One of the many features of Excel is being nosy. That's right, you can quickly calculate a persons age as long as you have their birth date.