> For the complete documentation index, see [llms.txt](https://docs.nedyx.com/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://docs.nedyx.com/nedyx/clearlines-functions/range-functions/cumulate.md).

# 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="/files/ZXhCZtRiZjR4ejBDcLKC" alt=""><figcaption></figcaption></figure></div>

<div align="left"><figure><img src="/files/2qDd6AlelbP6NpUsJuxh" alt=""><figcaption></figcaption></figure></div>

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

<div align="left"><figure><img src="/files/rpqdReWTVlWUsWgtxnii" alt=""><figcaption></figcaption></figure></div>