Countif formula now results in "Spill" error

Copper Contributor

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?

4 Replies

@STHATL1965 

Try

 

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

thank you!

@STHATL1965 

Just in case

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

returns the same

@Sergei Baklan It works! Thank you so much.