CODEWITHSUNDEEP
excelms-office
Rohan Sheth
Rohan Sheth

Reputation: 1

Excel Countif Function not evaluating

I am having an issue with using the countif function in excel. I enter the formula into the cells and click enter, but it doesn't evaluate at all; it just shows the text of the formula.Excel Formula Not evaluating

Please let me know what the issue is. Thank You!

Upvotes: 0

Views: 215

Answers (2)

Jordan
Jordan

Reputation: 4514

Under 'Formulas' in the toolbar un-select 'Show Formulas':

enter image description here

Upvotes: 1

kolcinx
kolcinx

Reputation: 2233

Is the Number format in cells with the formulas set to TEXT? If yes, apply General number format and then re-enter the formula in the cells.

Upvotes: 0

Related Questions