NOT Function

The NOT Function returns TRUE if the argument is false and FALSE if the argument is true.

=NOT(logical)

OR

The OR function returns TRUE if any argument is true and returns FALSE if all arguments are false.


=OR(logical1,logical2)

AND function

The AND function accepts two or more logical tests and displays TRUE if all conditions are true or FALSE if any of the conditions are false.

=AND(logical1,logical2)

COUNTIFS

COUNTIFS function counts the number of cells in a range that meet multiple criteria.

=COUNTIFS(C$2:C$13,"Account Rep",B$2:B$13,"Atlanta")

=COUNTIFS(criteria_range1, criteria1, criteria_range2, criteria2...)

AVERAGEIFS

AVERAGEIFS function calculates the average value of cells in a range that meet multiple criteria.

This function calculates the average value in the Salary range if the Title range contains Account Rep and if the Location range contains Atlanta.
=AVERAGEIFS(E$2:E$13,C$2:C$13,"Account Rep",B$2:B$13,"Atlanta")

=AVERAGEIFS(average_range,criteria_range1,criteria1,criteria_range2, criteria2...)

SUMIFS

The SUMIFS function calculates the total value of cells in a range that meet multiple criteria.

=SUMIFS(E$2:E$13,C$2:C$13,"Account Rep",B$2:B$13,"Atlanta")

=SUMIFS(sum_range, criteria_range1, criteria1, criteria_range2, criteria2...)

SUM_range
The sum_range argument designates the cells containing values to add if the condition is met. In the SUMIFS function, the sum_range argument is the first argument, instead of the last argument as in the SUMIF function.

Criteria_range1
The range argument specifies the first range of cells you want to evaluate to see if the values meet a particular condition. The range must contain values, range names, arrays, or references that contain numbers, dates, or text.

Criteria1. The criteria1 argument specifies the condition for the criteria_range1 argument that imposes limitations on what values are summed.

Criteria_range2. The range argument specifies the second range of cells you want to evaluate to see if the values meet a particular condition. The range must contain values, range names, arrays or references that contain numbers, dates or text.

Criteria2. The criteria2 argument specifies the condition that imposes limitations on what values are summed.

COUNTIF

COUNTIF function is similar to COUNT function except that it calculates the number of cells in a range that meet a specific condition you specific condition you specify instead of calculating the count of an entire range.

=COUNTIF(C2:C13,"Account Rep")

=COUNTIF(range, criteria)