This function ignores any text or empty cell within a data range. If you suspect wrong results from this function, look for text in the data ranges. To highlight text contents in a data range, use the value highlighting feature.

Any of the optional arguments can be omitted. An optional argument requires all preceding separators to be present.