> For the complete documentation index, see [llms.txt](https://shedmate.gitbook.io/shedmate-help/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://shedmate.gitbook.io/shedmate-help/setting-up-shedmate/costing-database-and-pricing-calculations/variables/mathematical-functions/average.md).

# AVERAGE

The AVERAGE function returns the average of the values in the specified range.

### Syntax:

<pre><code><strong>average(number1, number2, number3, ...)
</strong></code></pre>

### Parameters:

```
numbers (required): The range of numbers whose values will be used to calculate the average.
```

### Usage example:

<figure><img src="https://1247870272-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FSXoRgDyJukQzyOctBwWG%2Fuploads%2FPeIfDNb9tVsr1KIy7vKj%2FCaptura%20de%20Tela%202024-05-30%20a%CC%80s%2008.55.00.png?alt=media&amp;token=9fd15659-6e98-4dca-88cf-7a0aaa549d26" alt=""><figcaption></figcaption></figure>