• range: the range of cells to evaluate against the criteria.• criteria: the condition or criteria that must be met. This can be a number, text, date, logical expression or cell reference.• [average_range] (optional): the range of cells that will be used to calculate the average. If omitted, the function will use the same range as the range argument.