Hi Barbara You are correct but the only reference that needs to change is A12 The absolute references define the fixed arrays Thanks for your response Apologies for my late response Regards, Ken
-----Original Message----- From: Barbara Duprey [mailto:[email protected]] Sent: 10 December 2008 18:10 To: [email protected] Subject: Re: [users] copying a single cell array formula by dragging it down Ken Jolliffe wrote: > 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 I'm not really a user of Calc, but I suspect that the absolute cell references (with the $) are not able to be handled as relative ones with the drag operation. Is there a particular reason you're using the absolute references to begin with? --------------------------------------------------------------------- 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]
