I need to count data in one colum based on data in another column

[LG]

I have 5 different data options in column M and want to count them based on a
value in column I not being N/A. I have tried sever different statements and
can not get a valid answer. The latest is: =COUNT(M4:M199="FY06
Q4",(IF(I4:I199<>"N/A",1,0)))

 

[Barb Reinhardt]

Try this:

=SUMPRODUCT(--(M4:M199="FY06 Q4"),--(I4:I199<>"N/A"))