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.

Enter the formula as an array formula. Hint: enter formula using keys Ctrl + Shift + Enter.