| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
how can i use same range of data for different formulas in excel?
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? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Macro question | Excel Worksheet Functions | |||
| Excel 2002; copy formulas to one workbook to another diff data | Excel Worksheet Functions | |||
| Help PLEASE! Not sure what answer is: Match? Index? Other? | Excel Worksheet Functions | |||
| Excel Range Value issue (Excel 97 Vs Excel 2003) | Excel Discussion (Misc queries) | |||
| Fetching External Data from Excel | Excel Discussion (Misc queries) | |||
Threaded Mode
