|
In Excel a formula can be created using cells ranges
that are non-contiguous.
-
In the cell where the formula is to be appear
fill in the following:
=function(
(Example of function is sum, average etc).
-
Select the first range of cells to be included in
the formula (a "dancing" border will surround selection).
-
Press and hold down the
Ctrl key.
-
Select the remaining ranges.
-
"Dancing" borders will
surround the selections (see the sample below).
-
Press the Enter
key or the check mark in the formula bar to accept the formula.
In the sample below a
Sum
function
is used to calculate the non-contiguous ranges
B3:B9 and
D3:D9.
The formula can also be typed into a cell but using this mouse/selection
method can eliminate the problems of typos and other formula syntax
errors.
Printer Friendly Version
 |
