> 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/version-1.66/nedyx/clearlines-functions/mathematical-functions/sum.md).

# SUM

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

**SUM**(*range*; *orientation*)

* *range* - a range of values - ***Value type**: range*
* *orientation* - the orientation of the sum calculation - ***Value type**: constant (optional, <mark style="color:red;">all</mark> as default)*. Possible values are:
  * *<mark style="color:red;">all</mark>* - the sum of the whole range is returned as a single number
  * *<mark style="color:red;">horizontal</mark>* - the sum calculation is performed horizontally (row-wise) and returned as a column of numbers
  * *<mark style="color:red;">vertical</mark>* - the sum calculation is performed vertically (column-wise) and returned as a row of numbers

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

* Empty cells or cells which cannot be converted to numbers are ignored in the sum calculation.

#### Examples <a href="#examples.13" id="examples.13"></a>

![](/files/eLSajXFWGTOAdUPuZEJi)

![](/files/yiDPs4WrgdUzvgqXgju0)

![](/files/z7OzkviEI9FzOvpDR1G8)