The result of COUNTA is then divided by “size”, configured as a named range F4.
The named range is used only for readability and convenience.
The resulting value is then processed by the CEILING function, with a significance of 1.
CEILING is a rounding function that always rounds up to the next unit of significance.
In this example, this causes fractional values to be rounded up to the next integer.
If it is blank, we skip the count and return anempty string("").
COUNTA does not count empty cells.
CEILING Function
The Excel CEILING function rounds a given numberupto the nearest specified multiple.
CEILING works like theMROUND function, but CEILINGalways rounds up.
