Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
@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
Posted to microsoft.public.excel.newusers
|
|||
|
|||
@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
Posted to microsoft.public.excel.newusers
|
|||
|
|||
@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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Open Excel 2003 from Windows Explorer | Excel Discussion (Misc queries) | |||
excel viewer | Setting up and Configuration of Excel | |||
Excel file with hyperlinks takes a long time to open over the network | Links and Linking in Excel | |||
Equivalent of Minus in Excel. Also Union, Intersect. | Excel Worksheet Functions | |||
Excel equivalent of Matlab stem plot | Charts and Charting in Excel |