STOP EXCEL FROM COPYING ARRAY!

[MetLife]

Hi,

I type in this formula:
F12=COUNTIF(E11,'CIFE 831'!$C$10:$C$121173)

Then excel automatically copies the whole formula down the worksheet. I don't want this. It doesn't work if I delete the formula in cell F13, it just changes the result of F12 to SPILL!

This is so annoying it happens and it is almost impossible to get excel to just STOP@

 

[Fluff]

Maybe

=sum(COUNTIF(E11,'CIFE 831'!$C$10:$C$121173))

 

[shift-del]

Or maybe:

=COUNTIF('CIFE 831'!$C$10:$C$121173,E11)