###### Excel OR Function

The Excel OR function tests whether any arguments are TRUE, and returns TRUE if at least one argument is TRUE. If all arguments are FALSE the OR function will return FALSE.

###### Excel AND function

The Excel AND function tests whether all arguments are TRUE, and returns TRUE if all arguments are TRUE, or FALSE if any arguments are FALSE.

###### Excel IFERROR function

The Excel IFERROR function returns a specified value if the expression is an error. The IFERROR function is an Excel logical function.

###### Excel MAX IF formula

The MAX IF formula finds the maximum value from a range when a specific condition is met.

###### Excel AVERAGEIF function

The Excel AVERAGEIF function calculates the average value from a range of cells with a given condition. The AVERAGEIF function is useful for calculating the average of subset of an overall dataset (with a single criteria).

###### Excel AVERAGEIFS function

The Excel AVERAGEIFS function calculates the average value from a range of cells with a given condition or multiple conditions.

###### Excel COUNTIFS function

The Excel COUNTIFS function counts the number of occurrences of a condition or multiple conditions within a range of cells.

###### Excel COUNTIF function

The Excel COUNTIF function counts the number of occurrences of a condition within a range of cells. The COUNTIF function is useful for quickly counting instances of data within a dataset.

###### Excel SUMIFS function

The Excel SUMIFS function adds numerical values from a range of cells when certain condition(s) are true. The SUMIFS function is useful for summing specific subsets of data with one or more specific criteria.

###### Excel SUMIF function

The Excel SUMIF function adds numerical values from a range of cells when a condition is true. The SUMIF function is useful for summing specific subsets of data.

End of content