Countif formula now results in "Spill" error

Question

Need help...have researched this and the answers provided do not seem to work for me.

Trying to sue a simple countif formula I have used a hundred times:

=COUNTIF(B62,$B$2:$B$53)

To return the # of times a label appears in a range of cells

I am not getting a "Spill" error

It appears that I am supposed to use "@" to fix this in some way, but I have tried and it does not return the correct # of records. How can I get my old countif function back?

shelia0823 · Answer

SergeiBaklan&nbsp;It works! Thank you so much.

hansvogelaar · Answer

STHATL1965&nbsp;
Try
&nbsp;
=COUNTIF($B$2:$B$53,B62)

sthatl1965 · Answer

thank you!

sergeibaklan · Answer

STHATL1965&nbsp;
Just in case
=SUM(COUNTIF(B62,$B$2:$B$53))
returns the same

Forum Discussion

Countif formula now results in "Spill" error

Share

Resources