Countif function error



Can someone help me with the formula for the countif function. I am trying to compute the number of times an incident is projected on a specific month. I used count if function but since some cells have no value, it shows invalid data type. How can I ignore those cells and count only the cells that have a month data ?


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!