You could assign RangeNames to your ranges and use them in the formulas......
Select the range A1:D15, then do Insert Name Define and type AtoD in
the "Names in Workbook: small window OK.........then you can use formulas
like =SUM(AtoD), or =AVERAGE(AtoD), etc etc......

Then, highlight A1:E15 and name that range AtoE, and do the same thing.

hth
Vaya con Dios,
Chuck, CABGx3



"kysazas" wrote:

lets say I have a range of data A1:D15 and i need to calculate sum, average,
min, max, etc... of that range. Can I do that without reselecting all cells
A1:D15 or typing every time "sum(A1:D15)", "average(A1:D15)", "min..." and
etc.?
or maybe it is posible to program than one cell would contain all values of
the range? and it would be possible to click on that cell and all
calculations would be maid with values of that range?
and how would be to change range to A1:E16 and recalculate?