range of cells

The MAX formula is used to find the maximum value in a range of numbers. To use the MAX formula, select the cell where you want the result...

The MIN formula is used to find the minimum value in a range of numbers. To use the MIN formula, select the cell where you want the result...

The COUNT formula is used to count the number of cells in a range that contain numbers. To use the COUNT formula, select the cell where you want...

The COUNTA formula is used to count the number of cells in a range that are not empty. To use the COUNTA formula, select the cell where you...

The VLOOKUP formula is used to search for a value in the first column of a range of cells and return a value in the same row from...

The HLOOKUP formula is used to search for a value in the first row of a range of cells and return a value in the same column from...

The INDEX formula is used to return a value from a specified cell within a range of cells. To use the INDEX formula, select the cell where you...

The MATCH formula is used to search for a value within a range of cells and return the relative position of the value within the range. To use...