Countif Formula

[Khalid A. Al-Otaibi]

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.

 

[Jacob Skaria]

Try
=COUNTA(A1:A10)-COUNTIF(B1:B10,"N/A")

'If you want to count only if there is a numeric value in colA then you may
try
=SUMPRODUCT((ISNUMBER(A1:A100))*(B1:B100<>"N/A"))