compare

Previous chapterNext chapter Show allShow all    Hide allHide all

This function compares values in the stated area with a condition and returns the number of hits.

As a help for the definition this function can be selected from the menu entry Format/Functions (or with the right mouse button on the cell).

Syntax: =compare(area,condition)

Example Example

=compare(A1:A10,">=5")