Mar 13 2021 07:23 AM
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?
Mar 13 2021 07:28 AM
Mar 13 2021 11:32 AM
Dec 18 2022 12:44 AM
@Sergei Baklan It works! Thank you so much.