This month’s column introduces Excel’s GROUPBY function as a PivotTable alternative.

Excel's COUNT function produces a number of cells containing any value, but only COUNTIF and COUNTIFS can use conditions to narrow your results. The COUNTIF function is used for one condition ...

Use COUNTIF to count values in a range that meet a certain condition and return a specified number to the cell.

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

If you need to count duplicate values in a column in Excel, read through this article. Count duplicate values in a column in Excel The needful can be achieved using the COUNTIF function.

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