Conditional statements

NAME	DESCRIPTION
AVERAGEIF	Returns the average value in a list if they meet a certain criterion
COUNTIF	Returns the count of values in a list if they meet a certain criterion
FILTERIF	Returns the list of items that match the given condition
IF	Checks whether a condition is met, and returns one value if TRUE, and another value if FALSE
IFNA	Returns the value you specify if a formula returns the #N/A error value; otherwise, it returns the result of the formula
SUMIF	Returns the sum of values in a list if they meet a certain criterion
SWITCH	Evaluates an expression against a list of values and returns the result corresponding to the first matching value. If there is no match, an optional default value is returned