What is it you're trying to achieve by this formula?
I think your formula should be =if(sum($A$1:$A$10)=a12;sum($B$1:$B$10);0)
You're missing operators and OOo doesn't know what to do with the arrays
that you have defined. In the example I've given above Calc performs a
check that if the sum of A1-A10 equals the value of A1 in inserts the
sum of B1-B10 in the cell that contains the formula.
Does this answer your question?
Arnold Huzen
Ken Jolliffe schreef:
Hi guys
I have written a simple single cell array formula but when I drag it
down to copy to the cells below the relative reference does not change
This behaviour is different to Excel but I am sure that I simply need to
know the Openoffice way of doing things.
The formula is as follows
{=sum(if($A$1:$A$10=A12;$B$1:$B$10;0))}
When I drag it down the reference A12 does not change to A13,A14...etc.
Thanks
Ken
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
