Count
Count gives the number of values in a column, not counting empty values. In the table below, Column A has a Count of 3, while Column B has a Count of 4.
| Column A | Column B |
|---|---|
| 1 | 4 |
| 7 | |
| 8 | 3 |
| 9 | 6 |
CountBig is used when the number of counted values is very large. It returns a LongInteger instead of an integer.