Next: , Previous: Sorting by column, Up: Advanced Features

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.