Reference Operators
Excel suppoorts another class of operators known as reference opoerators. Reference operators, described in the following list, work with cell references.
:(colon)
Range opreator. Produce one reference to all the cells between two references.
,(comma)
Union operator. This combines multiple cell or range references into one reference.
(single space)
Intersection operator. This produces one reference to cells common to two references.