Re: [users] copying a single cell array formula by dragging it down

[Barbara Duprey]

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]