Function: MAX

Function: MAX

by

The Excel MAX function returns the maximum value in an array or range of cells. In this guide, we’re going to show you how to use the MAX function and also throw in some tips and error handling methods.Supported versionsAll Excel versionsExcel MAX Function...

Function: COLUMNS

Function: COLUMNS

by

The Excel COLUMNS function returns the number of columns in a selection. In this guide, we’re going to show you how to use this function and also go over some tips and error handling methods. Supported versions All Excel versions Syntax [box...

Function: ROWS

Function: ROWS

by

The Excel ROWS function is a Lookup & Reference formula that returns the number of rows in an array, an array formula, or a range of cells. In this guide, we’re going to show you how to use the Excel ROWS function and also go over some tips and error...

Function: COLUMN

Function: COLUMN

by

The Excel COLUMN function is a Lookup & Reference formula that returns the column number of a reference. In this guide, we’re going to show you how to use the Excel COLUMN function and also go over some tips and error handling methods.Supported...

Function: ROW

Function: ROW

by

The Excel ROW function is a Lookup & Reference formula that returns the row number of a reference. In this guide, we’re going to show you how to use the Excel ROW function and also go over some tips and error handling methods.Supported versionsAll...

Function: RANDBETWEEN

Function: RANDBETWEEN

by

The RANDBETWEEN function returns a random integer number between the numbers specified. In this guide, we’re going to show you how to use this function and also go over some tips and error handling methods.Supported versionsAll Excel versionsSyntax[box...

Function: RAND

Function: RAND

by

The RAND function returns an evenly distributed random numbers greater than or equal to 0 and less than 1. In this guide, we’re going to show you how to use the RAND function and also go over some tips and error handling methods.Supported versionsAll Excel...

Function: SUBTOTAL

Function: SUBTOTAL

by

The Excel SUBTOTAL function returns the subtotal of the specified values. The function works like a combination of aggregation formulas of Excel, and allows you to determine the function with the use of a separate parameter. What separates the SUBTOTAL...

Function: COUNT

Function: COUNT

by

COUNT is a statistics function that counts the numeric values within the specified range. A common use case for this function is counting the cells that have numeric values. In this guide, we’re going to show you how to use the COUNT function and also go...