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 allows to remove
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.
(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.