1 min read
I have this formula in a cell = COUNTIF(May!$E:$E,"o") when I attempt to change the "o" to "a" the formula displays in the cell as an actual formula
=COUNTIF(May!$E:$E,"a") displays in the cell but does not work.
Hope I make sense.
Looks right to me.
If you delete the equals sign (=) the formula would show in the cell as text - but of course there would be no equals sign showing.
Other than that, the only way I know how to show the formula in the cell - complete with equals sign - is to hold control and accent key (`). Formula would then continue to show until you click in the cell and hit Ctrl ` again.
As it turned out it was the cell format, I changed to general and that allowed the change.
AI can make mistakes. Check the cited posts. Archived advice can be out-of-date
Don't include personal information. Questions and selected public posts go to OpenAI. About Ask AI