ignore "0"
 

Hello from Steved

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

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

Thankyou.

ignore "0"
 

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.

ignore "0"
 

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.

ignore "0"
 

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.

ignore "0"
 

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.

ignore "0"
 

Thankyou

"T. Valko" wrote:

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.

ignore "0"
 

That answer made me even more confused

--


Regards,


Peo Sjoblom

"Steved" wrote in message
...
Thankyou

"T. Valko" wrote:

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.

ignore "0"
 

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

"Peo Sjoblom" wrote:

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.

ignore "0"
 

You're welcome!


--
Biff
Microsoft Excel MVP


"Steved" wrote in message
...
Thankyou

"T. Valko" wrote:

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.

ignore "0"
 

Me too!

?????

--
Biff
Microsoft Excel MVP


"Peo Sjoblom" wrote in message
...
That answer made me even more confused

--


Regards,


Peo Sjoblom

"Steved" wrote in message
...
Thankyou

"T. Valko" wrote:

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.