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

[Ken Jolliffe]

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