Excel First

Excel Solutions

Excel Reference Operators

There are 3 Reference Operators in Excel:

  1.   “:” (colon) is the Range operator, which produces one reference to all the cells between two cells references, including the cells written in the reference text, like: A11:A13
  2.  “,” (comma) is the Union operator, which combines multiple Ranges into one reference, like  A11:A13 , A11:C11 , A11 (you can refer to simple cells too, not only to ranges with multiple cells)
  3.  ” ” (space) is the Intersection operator, which returns a reference to the cell or to the range of cells found at the intersection of the ranges. In this example, only cell A11 is found in both ranges:  A11:A13  A11:C11

Read More