Next: More on cell printing, Previous: Sorting by column, Up: Advanced Features [Contents][Index]

### 4.4 Standard formula functions

Oftentimes you want a calculation to exclude the blank cells. Here are some useful functions to call from your formulas:

`(ses-delete-blanks &rest args)`

  Returns a list from which all blank cells (value is either `nil` or ’*skip*) have been deleted.

`(ses+ &rest args)`

  Sum of non-blank arguments.

`(ses-average list)`

  Average of non-blank elements in list. Here the list is passed as a single argument, since you’ll probably use it with `ses-range`.