The Count (Set) function includes or excludes empty cells, depending on the syntax used.
If the standard syntax is used, empty cells can be excluded or included by using the EXCLUDEEMPTY or INCLUDEEMPTY flags, respectively.
If the alternate syntax is used, the function always includes empty cells.
To exclude empty cells in the count of a set, use the standard syntax and the optional EXCLUDEEMPTY flag.
Returns the number of cells in a set.
The
Count (Set)function includes or excludes empty cells, depending on the syntax used. If the standard syntax is used, empty cells can be excluded or included by using theEXCLUDEEMPTYorINCLUDEEMPTYflags, respectively. If the alternate syntax is used, the function always includes empty cells. To exclude empty cells in the count of a set, use the standard syntax and the optionalEXCLUDEEMPTYflag.