Reference Operators

Reference Operators are an important part of understanding Excel Functions.

Reference Operators are split in to two groups: “range” and “union”, and they refer to either a single cell or a group of cells.

A “range” Reference Operator is an equation that entails a group of cells between one cell and another cell, for instance all the cells between and including B10 to B15. Taking the SUM Function as an example, in Excel we would write =SUM(B10:B15)

A “union” Reference Operator on the other hand is the joining or “unification” of two or more separate references in the same equation. This can include individual cells, numbers or range references – each one separated by a comma. Again, taking the SUM function as an example, we could write SUM=(A1,B10:15,A53,5). This equation will calculate the sum total of the numbers in cells A1, B10 to B15 inclusive, A53 and will then add 5 to the total.

Experiment with some ranges and unions of your own before we take a look at some other functions besides SUM.

Related posts:

1. Submitting Information
2. Text Wrapping
3. Basic Calculations
4. Auto Sum
5. Excel Functions

Similar resources you may like

Related posts:

1. Submitting Information
2. Text Wrapping
3. Basic Calculations
4. Auto Sum
5. Excel Functions

Tags

Excel, excel training, excel training sussex, excel tutorial, Free, microsoft, microsoft excel, Microsoft Office, resource, sussex, Tips, top Tips, Training

Share This Resource

• Digg
• Twitter
• Stumbleupon
• Delicious
• Facebook
• Myspace
• Google
• Technorati
• Newsvine