I can't see that formula has anything to do with "0",
it counts the string "Valley Flyer" and you could be more
efficient and use COUNTIF instead in this case

--


Regards,


Peo Sjoblom

"Steved" wrote in message
...
Hello from Steved

=SUMPRODUCT(--($D$2:$D$1989="Valley Flyer"))

Please how to I tell the above formula to ignore "0" if found.

Thankyou.