Possible to auto update formula?

[apollopt]

Hi,

I have like 500 lines that i need to make a formula COUNT with different names.
Whant i need to know is that if is possible to auto change the name in formula when changing lines.

I have an ex on attach.

Thanks in advance.

[martindwilson]

countif(m:m,a2) dragged down , however you seem to have more than one column. so you could do both at once =COUNTIF(M:N,A2)

[apollopt]

Thx m8.
It worked.