| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Can I use a different worksheet for my database using DSUM?
I'm trying to use DSUM and would like to have the result show in Worksheet 1
but use Worksheet 2 for my database, field and criteria. Unfortunately, the result is the total field column, not just the criteria cells. Is there a way to use a separate worksheet for the database, etc.? -- Sandee |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Creating worksheets from a database | Excel Discussion (Misc queries) | |||
| Autodate worksheet tab | Excel Discussion (Misc queries) | |||
| Retrieve data from all of the worksheet within the file | Excel Worksheet Functions | |||
| Populating worksheet via a drop down list ! | Excel Worksheet Functions | |||
| Obtaining information from a database for a worksheet | Excel Discussion (Misc queries) | |||
Hybrid Mode
