RANDBETWEEN – Excel Function
What it does: The RANDBETWEEN() Function generates a random number between two integers. Plain English: Rather than
RAND – Excel Function
What it does: The RAND() Function generates a random number between 0 and 1. Plain English: The random function is a brother
AVERAGE – Excel Function
The Average function only takes numbers as arguments, and calculates the arithmetic average of the data. These numbers can be
SMALL – Excel Function
What it does: The SMALL() Function provides the n-th smallest piece of data from an array. Plain English: The SMALL()
LARGE – Excel Function
What it does: The LARGE() Function provides the n-th largest piece of data from an array. Plain English: The LARGE() Function
COUNTIFS – Excel Function
What it does: The COUNTIFS() Function allows you to count the number of cells that match multiple criteria. Plain English:
SUMIF – Excel Function
What it does: The SUMIF() Functions sum together values based on criteria you provide. Plain English: The SUMIF() formula is
COUNTA – Excel Function
What it does: The COUNTA() function counts the number of cells that are not blank Plain English: This function is similar to
COUNTIF – Excel Function
What it does: The COUNTIF() function counts the number of cells that meet a certain criteria. Plain English: This function is