Statistical Functions

The MEDIAN function calculates the middle value of a given set of numbers. For example, the function returns 3 in =MEDIAN(1;2;3;4;5). The MEDIAN function contains the following arguments: =MEDIAN(number1; [number2]; …)  Number1 (Required Argument): The range of one or more cells

The MAX function returns the maximum or largest number in a given set of values or arguments. The MAX function ignores text and logical values in its calculations. The MAX function uses the following argument: =MAX(number1; [number2]; …) Number1 (Required

The MIN function returns the smallest numeric value from a given set of values. The function ignores text entries and logical values (TRUE/FALSE) in its calculations. The MIN function uses the following syntax: =MIN(number1; [number2]; …)  Number1 (Required Argument): The first

The AVERAGEIFS function calculates the average (arithmetic mean) of cells that meet multiple specified criteria. This function supports logical operators (<, >, <>) and wildcards (*, ?) in its criteria and was introduced in Excel 2007. The AVERAGEIFS function uses

The AVERAGEIF function calculates the average of cells that meet specified criteria. This function supports logical operators (<, >, <>, =) and wildcards (*, ?) in its criteria. The AVERAGEIF function uses the following syntax: =AVERAGEIF(range; criteria; [average_range])  Range (Required

The AVERAGE function calculates the arithmetic mean of a specified set of values in a worksheet. This function can accept up to 255 arguments, including cell references, ranges, arrays, and constants. The AVERAGE function uses the following arguments: =AVERAGE(number1; [number2];

The COUNTBLANK function calculates the number of empty cells within a specified range in a worksheet. The COUNTBLANK function requires a single argument: =COUNTBLANK(range)  Range (Required Argument): This specifies the cell range where blank cells should be counted. USING THE COUNTBLANK

The COUNTA function is a function that returns the number of non-empty cells within a specified range. This function excludes empty cells from its count. The COUNTA function may also be known as the Excel COUNTIF Not Blank formula. The

The COUNTIFS function is a function used for counting cells that meet single or multiple conditions or criteria. Just like the COUNT and COUNTIF functions, the COUNTIFS function is used with criteria or conditions relating to numbers, dates, text, logical

The COUNTIF function is used to count the number of cells that meet a certain criterion or condition. This can also be used to count cells that contain dates, numbers, and text. This function also supports the use of logical

The COUNT function is a function that counts the number of cells containing numbers, as well as the number of arguments that include numerical values. The COUNT function uses the following syntax: Value1 (Required Argument): The cell range or value