Count Functions in Excel

Statistical functions perform calculations based on certain criteria. Countif is used to count a range of selected cells that meet a specified criteria. Countblank counts the number of blank cells in a range of cells. Rank.Eq displays the rank of a selected cell within a range of cells. These are useful functions to perform calculations on data contained within a worksheet.

Countif

Open a workbook with a list of values Select the cell you want to place your answer into On the Formulas tab in the Function Library, select More Functions then Statistical Select CountIf Select the Range of cells within the list of values Enter the Criteria as the number you want to set as the criteria of each cell that will be counted Click OK This will Count the cells with the value you specified with the criteria

Countblank

Select the cell you want to place an answer in On the Formulas tab in the Function Library, select More Functions then Statistical Select CountBlank Select the cell Range within the list of values Click OK This Counts the Blank cells in the Range of cells

For more information about Advanced Excel, view the eBook below: