If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
@DSUM (123) equivalent in excel
Long time 123 user converting to excel . Trying to find equivalent function in excel. In 123 I can connect to a dbase IV (*.dbf) table using a macro. example: {DATABASE-CONNECT "dBASE_IV";;;;"c:\apfolder";;;;"table01";"table01" } END example Once this is done I can pull data from that table using @dsum (SQL)formulas in the cells. example: @DSUM(table01,"Quantity",Country=$A15#AND#Customer =B$13) END example. Can anyone help directly or steer me to someone that can explain how to do this with excel. BTW: I am hoping I can use the existing tables in the dbase IV format. -- jdelayknee ------------------------------------------------------------------------ jdelayknee's Profile: http://www.excelforum.com/member.php...o&userid=36607 View this thread: http://www.excelforum.com/showthread...hreadid=563485 |
#2
|
|||
|
|||
@DSUM (123) equivalent in excel
Hello
You can use this using Excel Database Function ,i.e Dsum as given below =DSUM(table01,"Quantity",E2:F3) so first the function name(in the name of the range of database, or select the entire data with heading,then the total on the coloumn u want,and then the criteria range) some where you need to have criteria as below [E2:F3] Customer Country Vipul India Know if you condition is same row then it is and condition and if the condition is different row then it is or condition. I hope it will help u Thanks Vipul C Dani "jdelayknee" wrote: Long time 123 user converting to excel . Trying to find equivalent function in excel. In 123 I can connect to a dbase IV (*.dbf) table using a macro. example: {DATABASE-CONNECT "dBASE_IV";;;;"c:\apfolder";;;;"table01";"table01" } END example Once this is done I can pull data from that table using @dsum (SQL)formulas in the cells. example: @DSUM(table01,"Quantity",Country=$A15#AND#Customer =B$13) END example. Can anyone help directly or steer me to someone that can explain how to do this with excel. BTW: I am hoping I can use the existing tables in the dbase IV format. -- jdelayknee ------------------------------------------------------------------------ jdelayknee's Profile: http://www.excelforum.com/member.php...o&userid=36607 View this thread: http://www.excelforum.com/showthread...hreadid=563485 |
#3
|
|||
|
|||
@DSUM (123) equivalent in excel
Thanks Vipul, I understand what you gave me when the data is embedded in the spreadsheet and is identified with a range. My data resides in separate files, example table01.dbf. See my first note. I first use a macro in the spreadsheet to access this dbf file. Then the formula in the cell does the dsum. -- jdelayknee ------------------------------------------------------------------------ jdelayknee's Profile: http://www.excelforum.com/member.php...o&userid=36607 View this thread: http://www.excelforum.com/showthread...hreadid=563485 |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Excel file with hyperlinks takes a long time to open over the network | Didier P | Links and Linking | 3 | July 4th, 2006 04:39 PM |
Multiple Excel versions. | Naveen Mukkelli | General Discussion | 0 | May 16th, 2006 12:55 AM |
Excel Range Value issue (Excel 97 Vs Excel 2003) | Keeno | General Discussion | 2 | June 13th, 2005 02:01 PM |
Windows in Taskbar | Chevy | General Discussion | 8 | October 15th, 2004 03:57 PM |
Coverting Lotus 123 files to use with excel | Muffin1947 | General Discussion | 6 | June 20th, 2004 10:18 AM |