# COUNT

#### Syntax <a href="#syntax.13" id="syntax.13"></a>

**COUNT**(*range*; *orientation; option*)

* *range* - a range of values - ***Value type**: range*
* *orientation* - the orientation of the count calculation - ***Value type**: constant (optional, <mark style="color:red;">all</mark> as default).* Possible values are:
  * *<mark style="color:red;">all</mark>* - the whole range is counted and returned as a single number
  * *<mark style="color:red;">horizontal</mark>* - the count calculation is performed horizontally (row-wise) and returned as a column of numbers
  * *<mark style="color:red;">vertical</mark>* - the count calculation is performed vertically (column-wise) and returned as a row of numbers
* *option* - defines if empty cells are counted as well - ***Value type**: constant (optional, <mark style="color:red;">nonemptycells</mark> as default)*\
  Possible values are:
  * *<mark style="color:red;">numericcells</mark>*
  * *<mark style="color:red;">nonemptycells</mark>*
  * *<mark style="color:red;">allcells</mark>*

#### Remarks <a href="#remarks.10" id="remarks.10"></a>

* If parameter 3 is defined, parameter 2 must be defined as well.

#### Examples

<figure><img src="https://3148043601-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FL43fiRbeRtPnTjMpbGNO%2Fuploads%2Fgit-blob-0af1ba92f79fa6822bd648bee5ef822dea819bdb%2Fgrafik%20(205).png?alt=media" alt=""><figcaption></figcaption></figure>

<figure><img src="https://3148043601-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FL43fiRbeRtPnTjMpbGNO%2Fuploads%2Fgit-blob-6f18f1948d14a13bd9bfb518461ee74cd47bdbe9%2Fgrafik%20(151).png?alt=media" alt=""><figcaption></figcaption></figure>

<figure><img src="https://3148043601-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FL43fiRbeRtPnTjMpbGNO%2Fuploads%2Fgit-blob-8ff2ffbbf08e980528ba5075f9cdc4184f0fefcb%2Fgrafik%20(301).png?alt=media" alt=""><figcaption></figcaption></figure>