CellSpace/Manual (draft)
by CellWorks
Home
  
Table of Contents
  
Glossary
Ranges
Ranges of are used to aggregate values, often with the sum() function.
  • Ranges can also be passed as arguments to user defined .
  • Ranges
    have the form:
  • 	<left_cell_coordinate> : <right_cell_coordinate>
  • For example:
  • 	=sum(B26 : J30)
  • Where B26 : J30 is a two-dimensional range of cells in a .
  • Ranges are also formed with named .
  • For example:
  • 	=sum(Oranges : Apples)
  • Where Oranges and Apples are named in a 'Products' .