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
’*skip*) have been deleted.
(ses+ &rest args)
Sum of non-blank arguments.
Average of non-blank elements in list. Here the list is passed
as a single argument, since you’ll probably use it with