Countif function error

Praz

Hi,

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 ?

Paul Newcome

You need to correct the error in the [Projected Months] column. I suggest wrapping whatever formula you have in that column in an IFERROR.