Forum Discussion
Formulae in Excel Resolving as a Static Value
In an excel sheet I have been attempting to use the COUNTIF formula to count instances of something appearing within a range, however, after typing the formula into the cell and hitting enter, the va...
I have discovered what the problem was.
If anyone is curious, the tab where I was attempting to use formulae had code in it (when you right click on the tab at the bottom of the screen, in the View Code option, it will bring up the code). This code was causing the above problem.
Thanks.