Excel 2 - C02

AND function

used to determine if ALL logical conditions are true

• T = all conditions are satisfied

• F = at least 1 condition is not satisfied

Syntax: AND function

= AND (logical 1, logical 2…)

OR function

used to test multiple conditions and determine if at least 1 condition is true

• T = at least 1 condition is satisfied

• F = all conditions are unsatisfied

Syntax: OR function

= OR (logical 1, logical 2…)

COUNTIFS function

counts the number of observations that satisfy a condition

Syntax: COUNTIFS function

= COUNTIFS (criteria range 1, criteria 1, criteria range 2, criteria 2…)

SUMIFS function

adds the values in a specified column that meet the conditions

Syntax: SUMIFS function

= SUMIFS (sum range, criteria range 1, criteria 1, ….)

T/F: you dont need “___” around the range of the criterion for SUMIFS or COUNTIFS

F