Did you use the absolute reference in your formula?

$A:$A