top of page
Search

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

  1. Open a workbook with a list of values

  2. Select the cell you want to place your answer into

  3. On the Formulas tab in the Function Library, select More Functions then Statistical

  4. Select CountIf

  5. Select the Range of cells within the list of values

  6. Enter the Criteria as the number you want to set as the criteria of each cell that will be counted

  7. Click OK

  8. This will Count the cells with the value you specified with the criteria


Countblank

  1. Select the cell you want to place an answer in

  2. On the Formulas tab in the Function Library, select More Functions then Statistical

  3. Select CountBlank

  4. Select the cell Range within the list of values

  5. Click OK

  6. This Counts the Blank cells in the Range of cells

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


 
 
 

Comentarios

bottom of page