COUNTIF function isn't showing my count right in the cell

[RayGriffin333]

I'm using a formula example here; =COUNTIF(A3:O82, "VB&T"). at first, it was working flawlessly. then when i went back to my information the count showed all as "0". I checked the equation function and it showed my result, but it didn't show the correct result in the actual cell. what am I missing? 

[#2 · Accepted solution]

@RayGriffin333 

Check the status bar - does it say "Circular References"?

If the cell with the COUNTIF formula is in the range A3:O82, the formula would cause a circular reference and return 0.

[#3]

When I went to check on the "Circular References" for some reason some random formulas were put in the excel... But removing them fixed the issue so thank you for the help