How to count with 2 status combined?

Referring to http://www.excelforum.com/excel-gene...ml#post2350875

I tried to filter again by counting only fruits that have status that is not "NIL".

=SUMPRODUCT((B3:B15="Apple")*(C3:C15<>"NIL")/COUNTIF(A3:A15,A3:A15&""))

I get weird numbers in the end. I have attached a sample here. My excel is ver 2000.
I have highlighted red on the questionable cells.