Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Passing a WorkSheet from a Function??? | Excel Worksheet Functions | |||
numerical integration | Excel Discussion (Misc queries) | |||
Changing worksheet cells from within a function | Setting up and Configuration of Excel | |||
changing type style and colour within a worksheet function | Excel Worksheet Functions | |||
Reference the worksheet from a multiple worksheet range function ( | Excel Worksheet Functions |