ignore "0"

  • Thread starter Thread starter Steved
  • Start date Start date
S

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

T. Valko said:
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"),"")
Click to expand...
 
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 ).
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Compare A&B columns with C&D columns 4
Return a blank cell 2
Scrabble Value calculation for Welsh words 0
In column B:B and D:D I've a Formula 6
Formula Issue 5
106% to this please 6% 7
Corporated into the same fromula please. 5
#value error for sumproduct using RIGHT cmd 0

Back
Top