A B
1 112233 Expired
2 113344 Valid
3 116655 Valid
4 117799 N/A

This Formula is to calculate the number of employee in the column.

=COUNTIF(A1:A4,"*").

Can I make it =COUNTIF(A1:A4,"*")- N/A.

I mean I want it the formula to calculat the number of employee but if the
Column B has the work N/A. include it in the calculation.