@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.

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

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.