Do you mean if the result is 0 return something other than 0 like a blank
cell?

Try this:

=IF(COUNTIF($D$2:$D$1989,"Valley Flyer"),COUNTIF($D$2:$D$1989,"Valley
Flyer"),"")

--
Biff
Microsoft Excel MVP


"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.