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) |