Forum Discussion
Solved
COUNTIF function isn't showing my count right in the cell
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?
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.
2 Replies
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.
- 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
