Hi Arnold Thanks for responding. I apologise for the delay in getting back to you. At the moment we are evaluating openoffice for use within our accountancy practise. I am checking out the array formulas as this is a useful feature for us. I know that there are alternative methods of achieving what my array formula does but as I have said array formulae are useful to us. Thanks Arnold Regards, Ken
-----Original Message----- From: Arnold Huzen [mailto:[email protected]] Sent: 10 December 2008 17:55 To: [email protected] Subject: Re: [users] copying a single cell array formula by dragging it down 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] --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
