| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
pointing to the full list from a database query
If I understand you correctly, a formula like:
=AVERAGE(B2:B11) will work correctly regardless of the number of filled cells in the range. Such a formula can be placed anywhere below B11 or above B2 (if you have a limited set of formulas you can consider placing them above the data). Does this help? Kostis Vezerides |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Access import query list incomplete | Excel Worksheet Functions | |||
| ODBC database query | Excel Discussion (Misc queries) | |||
| Excel Database Query | Setting up and Configuration of Excel | |||
| AHHHH-Get Data from Multiple Excel workbooks | Excel Discussion (Misc queries) | |||
| Dependent List Query | Excel Worksheet Functions | |||
Hybrid Mode
