ALL ABOUT OFFICE

EXCEL

HOME

ACCESS

EXCEL

WORD

OUTLOOK

POWERPOINT

Reference Operators

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.

webmaster@allaboutoffice.co.uk