Dave Bruns

The RAND function returns a random decimal number between 0 and 1. For example, =RAND() will generate a number like 0.422245717. The RAND function takes no arguments. RAND recalculates when a worksheet is opened or changed....Read more

The COUNTA function counts cells that contain values, including numbers, text, logicals, errors, and empty text (""). COUNTA does not count empty cells.

The COUNTA function returns the count of values in the list of supplied arguments....Read more

The COUNT function returns the count of numeric values in the list of supplied arguments. COUNT takes multiple arguments in the form of value1, value2, value3, etc. Arguments...Read more

The AVERAGEIF function calculates the average of the numbers in a range that meet supplied criteria. To apply criteria, the AVERAGEIF function supports logical operators (>,<,<>,=) and wildcards...Read more

The AVERAGEA function returns the average of a set of supplied values. AVERAGEA will include the logical values TRUE and FALSE, and numbers represented as text in the calculation. The AVERAGE function ignores these values during calculation

...Read more

The MODE function returns the most frequently occurring number in a set of numeric data. If supplied data does not contain any duplicate numbers, the MODE function returns a #N/A error.

The MODE function takes multiple arguments in the form ...Read more

The MEDIAN function returns the median (middle number) in a set of data. The calculation performed by MEDIAN varies according to the number of numeric values provided. When the number is odd, MEDIAN returns the middle number in the group. When the number is even, MEDIAN returns the average of...Read more

The AVERAGE function calculates the average of numbers provided as arguments. To calculate the average, Excel sums all numeric values and divides by the count of numeric values.

AVERAGE takes multiple ...Read more