how to create disjoint range for formula, chart, etc.

[Larry]

Need to create a disjoint range for formulas and charts,
e.g., c1:c4 & c7:c10 & c15:c17

The ranges are created manually by analysis of external
data, so there is nothing else in the sheet to condition
this on.

Would like to avoid having to use another column with
indicators for which cells are in the range (in which case
SUMPRODUCT would work).

 

[hgrove]

Larry wrote...
...

Need to create a disjoint range for formulas and charts, e.g.,
c1:c4 & c7:c10 & c15:c17

...

There's no way to do this without using another range to consolidate
these values into a single area range.

Note that you can use such ranges, (C1:C4,C7:C10,C15:C17) *with* the
enclosing parentheses, in consolidation functions, i.e., functions that
return a single value from many values, such as SUM and AVERAGE. Charts,
on the other hand, require single area ranges - no work-arounds.