Countif formula now results in "Spill" error

New 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:


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





thank you!


Just in case


returns the same

@Sergei Baklan It works! Thank you so much.