EXCEL
When you are entering
a formula you can use reference operators to choose a range of cells
to apply a formula to or to make the formula apply to a group of
cells that are not adjacent.
Reference operator |
Meaning |
Example |
: (colon) |
Range operator, which produces one reference to all the cells between two references, including the two references |
=SUM(B5:B15) Totals all the cells from B5 to B15 inclusive. |
, (comma) |
Union operator, which combines multiple references into one reference |
=SUM(B5:B15,D5:D15) Totals all
the cells from B5 to B15 and D5 to D15 together. |
Click here to return to the Excel index.