To add the values in B2:B5 in ses-mode I would write

    (+ B2 B3 B4 B5)
or

    (apply '+ (ses-range B2 B5))

[![simple table][1]][1]

but how can I generate the values in the range C2:C5 from B2:B5?




  [1]: https://i.sstatic.net/01XcH.jpg