Explanation
In this example, the goal is to count the maximum number of consecutive monthly orders.
That is, we want to count consecutive monthly orders greater than zero.
This is a tricky formula to understand, so buckle up!
They key to the formula is knowing that theFREQUENCY functiongathers numbers into “bins” in a particular way.
If so, IF returns the column number using theCOLUMN function.
Those columns where the count is zero become FALSE.
This is by design, to catch any values greater than the largest value in thebins_array.
MAX ignores empty cells, the logical values TRUE and FALSE, and text values.
More than one condition can be tested by nesting IF functions.
