how can i use same range of data for different formulas in excel?

[Guest]

lets say I have a range of data A115 and i need to calculate sum, average,
min, max, etc... of that range. Can I do that without reselecting all cells
A115 or typing every time "sum(A115)", "average(A115)", "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?

 

[Guest]

First define a Name for the range of Cells by pressing CTRL + F3.
Then select the range to which that name applies.
Eg :
=Sheet1!$A$1:$A$10
and add a name for it to be identified by eg. MyRange

thats it and then use it any number of times by simply replacing the name in
place of the range $A$1:$A$10

eg : =Sum(MyRange)

 

[robert111]

name, say, A1 to H35 as "myrange"

then use formulas such as AVERAGE(myrange)

this will accomodate increasing data, but check if average counts blank
cells, as that would introduce an error - perhaps have to work out
average by SUM(myrange)/COUNT(myrange)

 

[Guest]

You could assign RangeNames to your ranges and use them in the formulas......
Select the range A115, 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