Statistical Functions
- Conor Jordan
- Jul 30, 2021
- 1 min read
Statistical Functions
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. Create the following table:
2. Select cell B16
3. On the Formulas tab in the Function Library, select More Functions then Statistical
4. Select CountIf
5. Select the Range B2:B14
6. Enter the Criteria as >30
7. Click OK
8. This will Count the cells with a value greater than 30
Countblank
Select cell B17
On the Formulas tab in the Function Library, select More Functions then Statistical
Select CountBlank
Select the cell Range B2:B14
Click OK
This Counts the Blank cells in the Range
Rank.Eq
Select cell B18
On the Formulas tab in the Function Library, select More Functions then Statistical
Select Rank.Eq
In the Number text box select cell B13
In the Ref text box select the range B2:B14
Click OK
This will find the rank of the selected number in that range
Save the spreadsheet as “Statistical Functions”
For more information about Advanced Spreadsheet features, click on the paperback cover below:
Comments