View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
andresg1975 andresg1975 is offline
external usenet poster
 
Posts: 60
Default lotus 123 worksheet function conversion

i have a worksheet like this:

column c d e f

row 3 date number amount
row 4 08/31/2006 13610 294.96 @dsum($data,"amount",number=d4)

the data range contains this fields:

date number amount

if it contains number 13610, the function will return the amount

when i open it as an excel file the function returns #name? , how can i
create an
equivalent function in excel that will return the same result.

thanks a lot for your help