ignore "0"

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

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

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

Steved

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

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

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

How to use/create code in MS Word to calculate age? 0
Transfer data between two tables 3
Range headings 0
Compare A&B columns with C&D columns 4
Add a sequence number(question number) to a paragraph which has a question and 4 options and answer 0
106% to this please 6% 8
In column B:B and D:D I've a Formula 3
Formula please to put a word in the left Cell ( "Roster" ) 3

Top