Home |
Search |
Today's Posts |
#1
|
|||
|
|||
How does the Database Function work in Excel
Please assist. I keep getting an error message. I set up my database, the
range field and the critera, but I still keep getting an error message. |
#2
|
|||
|
|||
Do you think we are telepathic? What kind of D function, what are the
criteria, how is the table set up? Btw, you can use other functions if you have problems with the D functions, they are kind of obsolete although they have similar criteria as the advanced filter so they can be worth learning just because of that -- Regards, Peo Sjoblom (No private emails please) "Jacquelynn" wrote in message ... Please assist. I keep getting an error message. I set up my database, the range field and the critera, but I still keep getting an error message. |
#3
|
|||
|
|||
Sorry about that. I am using the DSUM function. It is for my class so I
cannot subsitute any other function. I have two worksheets one the employee records and the other page for critera. On the emp records page it has ssn, name, raise, performance level, etc. I need the DSum function to calucate the total raise for all employees who have a level 1 performance. "Peo Sjoblom" wrote: Do you think we are telepathic? What kind of D function, what are the criteria, how is the table set up? Btw, you can use other functions if you have problems with the D functions, they are kind of obsolete although they have similar criteria as the advanced filter so they can be worth learning just because of that -- Regards, Peo Sjoblom (No private emails please) "Jacquelynn" wrote in message ... Please assist. I keep getting an error message. I set up my database, the range field and the critera, but I still keep getting an error message. |
#4
|
|||
|
|||
Assume the table is Sheet1!A1:D30, that the headers of the table are
SSN Name Raise Level On Sheet2 in A1 put Level and in A2 put 1 then use the formula =DSUM(Sheet1!A1:D30,"Raise",Sheet2!A1:A2) -- Regards, Peo Sjoblom (No private emails please) "Jacquelynn" wrote in message ... Sorry about that. I am using the DSUM function. It is for my class so I cannot subsitute any other function. I have two worksheets one the employee records and the other page for critera. On the emp records page it has ssn, name, raise, performance level, etc. I need the DSum function to calucate the total raise for all employees who have a level 1 performance. "Peo Sjoblom" wrote: Do you think we are telepathic? What kind of D function, what are the criteria, how is the table set up? Btw, you can use other functions if you have problems with the D functions, they are kind of obsolete although they have similar criteria as the advanced filter so they can be worth learning just because of that -- Regards, Peo Sjoblom (No private emails please) "Jacquelynn" wrote in message ... Please assist. I keep getting an error message. I set up my database, the range field and the critera, but I still keep getting an error message. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel function problems | Excel Worksheet Functions | |||
Update a Database Using Excel | Excel Worksheet Functions | |||
Simplify Vlookup function in Excel | Excel Worksheet Functions | |||
Excel error while trying to import data from an Access database - MSQRY32.exe has generated errors | Excel Discussion (Misc queries) | |||
Excel Send To function problem | Excel Discussion (Misc queries) |