I don't think that you can combine an actual cell reference with a formula generated cell reference. I tried to do it with a search for a second match and was unsuccessful. I ended up using another method. (See perpetual calendar messages)
If there is a way to do it I would like to know the answer too. $C$2:INDIRECT... Have you ever succeeded to use this method in another formula? "Todor Cholakov" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] Hello, I am using OpenOffice 2.0 on Windows 2000 and I have the following formula (in Calc): $B$1+($E$1-(ROW()-$A$1)*$B$1-SUM($C$2:INDIRECT(ADDRESS(ROW()-1;3))))*$D$1 and i have Error508 message (Error in brackets) I checked brackets and there was no problem. I parted the formula and discovered that the problem is with the column ":" semantics somehow. when I remove "$C$2:" it shows no errors and calculates ok(it shows a number, no error. I don't change anything about brackets). when I replace the whole INDIRECT(...) with C3 for exmple ( so it becomes ...SUM($C$2:C3)... ) there is also no problem -everything calculates as expected. I tried to exchange the two sides of the column but the error occurs again So I suppose that the problem is the programmed syntax of the column - to accept only constant cells and not references created by INDIRECT. The same file when opened in MS Excel has no problems and the formula result is displayed correctly. the formula is at cell A2, all referenced cells has positive values Todor Cholakov --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
