Next: More on cell printing, Previous: Sorting by column, Up: Advanced Features [Contents][Index]
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
.