Next: , Previous: , 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.