@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";"tabl e01" } 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.

Note: the data I query is in a separate fiel, NOT in a range on the
spreadsheet.

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=563778

@DSUM (123) equivalent in excel
 

Don't know if it's any use to you, but ToolsOptionsTransition has some
Lotus settings.

NickHK

"jdelayknee" wrote
in message ...

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";"tabl e01" } 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.

Note: the data I query is in a separate fiel, NOT in a range on the
spreadsheet.

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=563778