A function that multiplies corresponding components in ranges or arrays of
equal dimensions, and then returns the sum of those products. - ANSWER
=SUMPRODUCT(array1, [array2], [array3], ...)
A function that evaluates to TRUE only if all of the logical statements included
are true. - ANSWER AND(logical1, [logical2], . . .)
A function that evaluates to TRUE if any of the logical statements are true. -
ANSWER OR(logical1, [logical2], . . .)
A function that allows the user to specify the preferred output if the logical
statement is either true or false. - ANSWER IF(logical_test, [value_if_true],
[value_if_false])
A function that counts the number of cells that contain numbers. - ANSWER
COUNT(value1, [value2], . . .)
A function that counts the number of cells that are not blank. - ANSWER
COUNTA(value1, [value2], . . .)
A function that returns the smallest number in a given set of numbers. -
ANSWER MIN(number1, [number2], . . .)
A function that returns the largest number in a given set of numbers. -
ANSWER MAX(number1, [number2], . . .)
A function that returns the kth smallest value in a data set. - ANSWER
SMALL(array, k)
A function that returns the kth largest value in a data set. - ANSWER
LARGE(array, k)
, A function that returns the rank of a number in a list of numbers (Ref) using,
assigning the same rank to all members of a tie. - ANSWER
RANK.EQ(Number, Ref, [Order])
A function that returns the rank of a number in a list of numbers (Ref),
assigning the average rank to all members of a tie. - ANSWER
RANK.AVG(Number, Ref, [Order])
A function that returns the arithmetic mean of a given set of numbers. -
ANSWER AVERAGE(number1, [number2], . . .)
A function that returns the median of a given set of numbers. - ANSWER
MEDIAN(number1, [number2], . . .)
A function that returns the variance of a given set of numbers. - ANSWER
VAR.S(number1, [number2], . . .)
A function that returns the standard deviation of a given set of numbers. -
ANSWER STDEV.S(number1, [number2], . . .)
a function that returns the covariance between two sets of data. - ANSWER
COVARIANCE.S(array1, array2)
a function that returns the correlation between two sets of data. - ANSWER
CORREL(array1, array2)
a function that will count the number of cells within a specified range that meet
the specified single criterion. - ANSWER COUNTIF(range, criteria)
a function that will count the number of cells within a specified range that meet
all the specified criteria - ANSWER COUNTIFS(criteria_range1, criteria1,
[criteria_range2, criteria2],...)
a function that will find the sum of a range of cells that meet the specified single
criterion. - ANSWER SUMIF(range, criteria, [sum_range])
equal dimensions, and then returns the sum of those products. - ANSWER
=SUMPRODUCT(array1, [array2], [array3], ...)
A function that evaluates to TRUE only if all of the logical statements included
are true. - ANSWER AND(logical1, [logical2], . . .)
A function that evaluates to TRUE if any of the logical statements are true. -
ANSWER OR(logical1, [logical2], . . .)
A function that allows the user to specify the preferred output if the logical
statement is either true or false. - ANSWER IF(logical_test, [value_if_true],
[value_if_false])
A function that counts the number of cells that contain numbers. - ANSWER
COUNT(value1, [value2], . . .)
A function that counts the number of cells that are not blank. - ANSWER
COUNTA(value1, [value2], . . .)
A function that returns the smallest number in a given set of numbers. -
ANSWER MIN(number1, [number2], . . .)
A function that returns the largest number in a given set of numbers. -
ANSWER MAX(number1, [number2], . . .)
A function that returns the kth smallest value in a data set. - ANSWER
SMALL(array, k)
A function that returns the kth largest value in a data set. - ANSWER
LARGE(array, k)
, A function that returns the rank of a number in a list of numbers (Ref) using,
assigning the same rank to all members of a tie. - ANSWER
RANK.EQ(Number, Ref, [Order])
A function that returns the rank of a number in a list of numbers (Ref),
assigning the average rank to all members of a tie. - ANSWER
RANK.AVG(Number, Ref, [Order])
A function that returns the arithmetic mean of a given set of numbers. -
ANSWER AVERAGE(number1, [number2], . . .)
A function that returns the median of a given set of numbers. - ANSWER
MEDIAN(number1, [number2], . . .)
A function that returns the variance of a given set of numbers. - ANSWER
VAR.S(number1, [number2], . . .)
A function that returns the standard deviation of a given set of numbers. -
ANSWER STDEV.S(number1, [number2], . . .)
a function that returns the covariance between two sets of data. - ANSWER
COVARIANCE.S(array1, array2)
a function that returns the correlation between two sets of data. - ANSWER
CORREL(array1, array2)
a function that will count the number of cells within a specified range that meet
the specified single criterion. - ANSWER COUNTIF(range, criteria)
a function that will count the number of cells within a specified range that meet
all the specified criteria - ANSWER COUNTIFS(criteria_range1, criteria1,
[criteria_range2, criteria2],...)
a function that will find the sum of a range of cells that meet the specified single
criterion. - ANSWER SUMIF(range, criteria, [sum_range])
