Returns 35, because only the second row participates in the calculation. The function searches what cells from the range A2:A6 contain only the word “pen”, and calculates the average of corresponding values from the B2:B6 range.
Returns 180, because only the fourth row participates in the calculation. The function searches what values from the range B2:B6 are less than the second large value in the B2:B6 range, and calculates the average of corresponding values from the C2:C6 range. Returns 113.3, because the fourth row (where there is the least value in the range B2:B6) does not participate in the calculation. The function searches what values from the range B2:B6 are greater than the least value in the B2:B6 range, and calculates the average of corresponding values from the C2:C6 range. Returns 25, because the first smallest value (the fourth row) does not participate in the calculation. In all examples below, ranges for calculation contain the row #6, which is ignored because it contains text.Ĭalculates the average for values of the same range that are greater than the first smallest value of this range. The expression can contain text, numbers, regular expressions or wildcards ( if enabled in calculation options). If the property Search criteria = and must apply to whole cells is true, the comparison is against the entire cell contents, if false, comparison is against any subpart of the field that matches the criteria. For = and, if the value is not empty and can not be interpreted as a Number type or one of its subtypes applies. A matching cell content equals the Number or Logical value.Ī value beginning with a comparator (, >=, ).įor =, if the value is empty it matches empty cells.įor, if the value is empty it matches non-empty cells.įor, if the value is not empty it matches any cell content except the value, including empty cells.įor = and, if the value is not empty and can not be interpreted as a Number type or one of its subtypes and the property Search criteria = and must apply to whole cells is checked, comparison is against the entire cell contents, if unchecked, comparison is against any subpart of the field that matches the criteria.
It is used in comparisons with cell contents.Ī reference to an empty cell is interpreted as the numeric value 0.Ī Number or Logical value. Criterion: A criterion is a single cell Reference, Number or Text.
0 kommentar(er)
