1. =AVERAGE(number1, [number2],...)
Description
Returns the average (arithmetic mean) of the arguments. For example, if the range (range: Two or more cells on a sheet. The cells in a range can be adjacent or nonadjacent.) A1:A20 contains numbers, the formula =AVERAGE(A1:A20) returns the average of those numbers.
=AVERAGE(A2:A6) Average of the numbers in cells A2 through A6.
2. =MAX Returns the largest value in a set of values.
Syntax
MAX(number1,number2,...)
Number1, number2, ... are 1 to 255 numbers for which you want to find the maximum value.
Example: If the value A3 has the largest number from A1 through A5 then it displays the value of A3.
=max(A1:A5)
3. =MIN(number1,number2,...) it is the opposite of =MAX. It returns the smallest value in a set of values.
4. The COUNT function counts the number of cells that contain numbers, and counts numbers within the list of arguments. Use the COUNT function to get the number of entries in a number field that is in a range or array of numbers. For example, you can enter the following formula to count the numbers in the range A1:A20:
=COUNT(A1:A20)
In this example, if five of the cells in the range contain numbers, the result is 5.
Syntax
COUNT(value1, [value2],...)The COUNT function syntax has these arguments (argument: A value that provides information to an action, an event, a method, a property, a function, or a procedure.):
value1 Required. The first item, cell reference, or range within which you want to count numbers.
value2, ... Optional. Up to 255 additional items, cell references, or ranges within which you want to count numbers.
Example: If A2 has value of 1 and A5 is 5 and A6 is equal to letter C then
=COUNT(A2:A8) is equal to 2. With this example, it counts the number of cells that contain numbers in cells A2 through A8.