Forum Discussion

Curdavid's avatar
Curdavid
Copper Contributor
Jan 30, 2022

COUNTIF FORMULA NOT EXECUTING

I have created a workbook which reflects values from a primary workbook.  When I use the COUNTIF formula to count the number of cells in which text occurs i.e.  COUNTIF(C3:C202,"*") the formula does ...
excel
Jihad Al-Jarady's avatar
Jihad Al-Jarady
MCT
Jan 30, 2022
Hello Curdavid,
You need to add = at the begining of the formula so Excel will do execute it.
=COUNTIF(C3:C202,"*")
  • Curdavid's avatar
    Curdavid
    Copper Contributor
    Jan 30, 2022
    I have an equal sign preceding the formula, I just didn’t mention it in my example.

Resources