# CUMULATE

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

**CUMULATE**(*range*; *orientation*)

* *range* - a range of values - ***Value type**: range with numbers as expected values*
* *orientation* - the orientation of the sum calculation - ***Value type**: constant (optional, vertical as default)*.\
  Possible values are:
  * *vertical* - the cumulated values are calculated column-wise
  * *horizontal* - the cumulated values are calculated row-wise

#### Remark

* Cells which cannot be converted to numbers are evaluated as 0 in the calculation of the cumulated values.

#### Examples

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

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

This example shows that letters and empty cells are evaluated as 0:

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