Where would Out of Service be?
--
** John C **


"Steved" wrote:

Sorry I meant "Out Of Service" not "0"

"Steved" wrote:

Hello from Steved

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

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

Thankyou.