Category: Excel Function

The AREAS function is to return the number of areas in a reference. An area is a cell or contiguous data range. Formula: = AREAS(array) Explanation: Array is required, …

The COLUMNS function returns the number of columns in an array or reference. Formula: = COLUMNS(array) Explanation: Array is required. The number of the columns of the data range …

The COLUMN function is to return the column number of a reference. Formula: = COLUMN () Explanation: Reference is optional. The column number of the cell or range of …

The ROWS function is to return the number of rows in a reference or array. Formula: = ROWS(array) Explanation: Array is required. The number of the rows of the …

The ROW function is to return the row number of a reference. Formula: = ROW() Explanation: The reference is optional. The row number of the cell or range of …

The ADDRESS function is one of the 16 Excel Reference Functions. The function returns the address of a cell in a worksheet with the specified row and column numbers. …