ignore "0"

[Steved]

Hello from Steved

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

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

Thankyou.

 

[Steved]

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

 

[Peo Sjoblom]

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

 

[T. Valko]

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"),"")

 

[John C]

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

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

 

[Steved]

Thankyou

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"),"")

 

[Peo Sjoblom]

That answer made me even more confused

--


Regards,


Peo Sjoblom

 

[Steved]

Hello Peo from Steved

You actually answered yourself by refering to "Valley Flyer"

And you gave me the answer I required and that was Countif

Cheers.

ps Now you are now back to normal ( Unconfused ).

 

[T. Valko]

You're welcome!


--
Biff
Microsoft Excel MVP

Thankyou

 

[T. Valko]

Me too!

?????

--
Biff
Microsoft Excel MVP

That answer made me even more confused

--


Regards,


Peo Sjoblom