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. Order of args is reverted. Please note that ses-range has a ! modifier that enables removing blanks, so it is possible to write:

(ses-range A1 A5 !)

instead of

(apply 'ses-delete-blanks (ses-range A1 A5 <))

(ses+ &rest args)

Sum of non-blank arguments taken in reverse order.

(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.