AVERAGEIFS

avg-values: A collection containing the values to be considered for the average value. avg-values is a reference to a single collection of cells, which may contain only number values or boolean values.

test-values: A collection containing values to be tested. test-values can contain any value.

condition: An expression that compares or tests values and results in the boolean value TRUE or FALSE. Condition can include comparison operators, constants, the ampersand concatenation operator, references, and wildcards. You can use wildcards to match any single character or multiple characters in the expression. You can use a ? (question mark) to represent one character, an * (asterisk) to represent multiple characters, and a ~ (tilde) to specify that the following character should be matched rather than used as a wildcard.

test-values…: Optionally include one or more additional collections containing values to be tested. Each test-values collection must be followed immediately by a condition expression. This pattern of test-values, condition can be repeated as many times as needed.

condition…: If an optional collection of test-values is included, an additional expression that results in a boolean value TRUE or FALSE. There must be one condition expression following each test-values collection; therefore, this function will always have an odd number of arguments.