Countif formula now results in "Spill" error

%3CLINGO-SUB%20id%3D%22lingo-sub-2207468%22%20slang%3D%22en-US%22%3ECountif%20formula%20now%20results%20in%20%22Spill%22%20error%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2207468%22%20slang%3D%22en-US%22%3E%3CP%3ENeed%20help...have%20researched%20this%20and%20the%20answers%20provided%20do%20not%20seem%20to%20work%20for%20me.%3C%2FP%3E%3CP%3ETrying%20to%20sue%20a%20simple%20countif%20formula%20I%20have%20used%20a%20hundred%20times%3A%3C%2FP%3E%3CP%3E%3DCOUNTIF(B62%2C%24B%242%3A%24B%2453)%3C%2FP%3E%3CP%3ETo%20return%20the%20%23%20of%20times%20a%20label%20appears%20in%20a%20range%20of%20cells%3C%2FP%3E%3CP%3EI%20am%20not%20getting%20a%20%22Spill%22%20error%3C%2FP%3E%3CP%3EIt%20appears%20that%20I%20am%20supposed%20to%20use%20%22%40%22%26nbsp%3Bto%20fix%20this%20in%20some%20way%2C%20but%20I%20have%20tried%20and%20it%20does%20not%20return%20the%20correct%20%23%20of%20records.%20How%20can%20I%20get%20my%20old%20countif%20function%20back%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2207468%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2207475%22%20slang%3D%22en-US%22%3ERe%3A%20Countif%20formula%20now%20results%20in%20%22Spill%22%20error%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2207475%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F996315%22%20target%3D%22_blank%22%3E%40STHATL1965%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3ETry%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%3DCOUNTIF(%24B%242%3A%24B%2453%2CB62)%3C%2FP%3E%3C%2FLINGO-BODY%3E
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:

=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?

3 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