COUNTIF FORMULA NOT EXECUTING

Question

I have created a workbook which reflects values from a primary workbook.&nbsp; When I use the COUNTIF formula to count the number of cells in which text occurs i.e.&nbsp; COUNTIF(C3:C202,"*") the formula does not execute.&nbsp; The cell simply shows the formula.&nbsp; Any help?

jihad al-jarady · Answer

Hello Curdavid,You need to add = at the begining of the formula so Excel will do execute it.=COUNTIF(C3:C202,"*")

curdavid · Answer

I have an equal sign preceding the formula, I just didn’t mention it in my example.

detlef_lewin · Answer

Curdavid&nbsp;Hi&nbsp;Google search&nbsp;

curdavid · Answer

Good Morning

jihad al-jarady · Answer

Hi&nbsp;Curdavid&nbsp;&nbsp;Check this option:On Formulas tab --&gt; Formula Auditing&nbsp;group --&gt; click on Show Formulas&nbsp;

Forum Discussion

COUNTIF FORMULA NOT EXECUTING

7 Replies

Resources